nested loops only loop once

[toddlahman]

I am using two while loops that are nested. The first loop (post name)
returns the full column of results, but the second (post modified)
only returns the first row of the column. Is there another way I could
write this to get both loops to complete fully?

I am using the two while loops to pull data from different tables, and
insert that data into a list that has html code surrounding each loop.

while ($url = mysql_fetch_array($urls, MYSQL_ASSOC)) {
$pn = $url['post_name'];

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
$lm = $date['post_modified'];

echo "<b>";
echo $pn;
echo "</b>";
echo "more html";
echo date('Y-m-d', strtotime($lm));
echo "and more html";
}
}

Thank you.

HG

[sheldonlg]

to********@gmail.com wrote:

I am using two while loops that are nested. The first loop (post name)
returns the full column of results, but the second (post modified)
only returns the first row of the column. Is there another way I could
write this to get both loops to complete fully?

I am using the two while loops to pull data from different tables, and
insert that data into a list that has html code surrounding each loop.

while ($url = mysql_fetch_array($urls, MYSQL_ASSOC)) {
$pn = $url['post_name'];

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
$lm = $date['post_modified'];

echo "<b>";
echo $pn;
echo "</b>";
echo "more html";
echo date('Y-m-d', strtotime($lm));
echo "and more html";
}
}

Thank you.

HG

What is it that you want to see?

Are you sure that it is the inner loop that only appears once? From the
way it is written it appears that it is the outer loop that will echo
only once and the inner loop will exhaust itself on the first row from
the outer loop. IOW, it looks like you should get:

pn1 lm1
pn1 lm2
.....
pn1 lmn
pn2 no echo since the echo is inside the inner loop
.....
pnn no echo since the echo is inside the inner loop

[C. (http://symcbean.blogspot.com/)]

On Jul 23, 6:00 am, [e-mail] wrote:

I am using two while loops that are nested. The first loop (post name)
returns the full column of results, but the second (post modified)
only returns the first row of the column. Is there another way I could
write this to get both loops to complete fully?

I am using the two while loops to pull data from different tables, and
insert that data into a list that has html code surrounding each loop.

while ($url = mysql_fetch_array($urls, MYSQL_ASSOC)) {
$pn = $url['post_name'];

while ($date = mysql_fetch_array($lmdate, MYSQL_ASSOC)) {
$lm = $date['post_modified'];

echo "<b>";
echo $pn;
echo "</b>";
echo "more html";
echo date('Y-m-d', strtotime($lm));
echo "and more html";
}

}

Thank you.

HG

Its not a PHP problem - I write nested loops all the time. How
confident are you that both queries are returning more than row? Have
you checked if it is throwing an error?

I don't know if you've deliberately edited down the code for
illustration purposes, but do you really intend to get a Cartesian
Product of the two queries?

C.

[toddlahman]

I am a new to this so forgive my ignorance. Realizing that using two
loops for two arrays was not outputting the desired results, I then
combined both arrays into one while loop. Then I pulled out the data I
wanted from each loop into a variable, and outputted that into the
form. The trick was to output two lists at the same time like this:
1
2
1
2
1
2

To create one big list. Here's how I did it for anyone having the same
difficulty.

while ( ($url = mysql_fetch_array($urls, MYSQL_ASSOC)) && ($date =
mysql_fetch_array($urls, MYSQL_ASSOC)) ) {
$pn = $url['post_name'];
$lm = $date['post_modified'];

echo "<b>";
echo $pn;
echo "</b>";
echo "more html";
echo date('Y-m-d', strtotime($lm));
echo "and more html";

}

Outputs
$pn
$lm
$pn
$lm
$pn
$lm

[sheldonlg]

to********@gmail.com wrote:

I am a new to this so forgive my ignorance. Realizing that using two
loops for two arrays was not outputting the desired results, I then
combined both arrays into one while loop. Then I pulled out the data I
wanted from each loop into a variable, and outputted that into the
form. The trick was to output two lists at the same time like this:
1
2
1
2
1
2

To create one big list. Here's how I did it for anyone having the same
difficulty.

while ( ($url = mysql_fetch_array($urls, MYSQL_ASSOC)) && ($date =
mysql_fetch_array($urls, MYSQL_ASSOC)) ) {
$pn = $url['post_name'];
$lm = $date['post_modified'];

echo "<b>";
echo $pn;
echo "</b>";
echo "more html";
echo date('Y-m-d', strtotime($lm));
echo "and more html";

}

Outputs
$pn
$lm
$pn
$lm
$pn
$lm

Uh, if the above output is what you want, why don't you simply combine
the two into a single query with a "join"?

select u.post_name as pn, d.post_modified as lm
from the_table_for_ul u
join the_table_for_date d on
(u.something = d.something_else)
the something and something_else are matching keys in the two tables.

Then, after doing:
$result = mysql_query(the_select_statement_above)
all you need do is have

while ($row = mysql_fetch_array($result)) {
$pn = $row['pn'];
$lm = $row['lm'];
}