nested while loops

[TheDust]

I am iterating through a query's result using a WHILE loop. Then, inside of that, I want to iterate through the rows of data from ANOTHER query's results, but as is it will only run that nested WHILE loop once and skip it on the next passings. It looks like this:

while ($row = mysql_fetch_assoc($results)) {
### stuff ###
while ($row2 = mysql_fetch_assoc($results2)) {
### stuff ###
}
### stuff ###
}

Anyone know why after the first iteration through, the nested loop is skipped over?

 

[casters]

It should not. There is something wrong in your code. For example: are you sure you are not using the same variable for the two queries (perhaps an intermediate variable used to create $row and $row2?).
Gaetano

 

[danielhozac]

Because you have already iterated through all the records in the resultset, there are no more records to fetch the second time. //Daniel

 

[casters]

...of course, the second query must be included inside the WHILE loop (not before it), so it is run for every $row.

Gaetano

 

[sleipnir214]

Since the internal while loop is looping through a different resource handle than the first, I would guess it's because the query $results2 is based on returned no rows. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[skiflyer]

I'd wager a different guess, but you haven't given us all the information...

you say (with some editing
### stuff0 ###
while ($row = mysql_fetch_assoc($results)) {
### stuff1 ###
while ($row2 = mysql_fetch_assoc($results2)) {
### stuff2 ###
}
### stuff3 ###
}


now, for your nested looping to make any sense,
### stuff1 ###

should include a line saying something like
$results2 = mysql_query($query);

if it doesn't, then ### stuff0 ### and ### stuff3 ### must

If neither of those is the case, then the problem is as danielhozac said, and you probably just need to put the pointer back to the beginning of the recordset.

If one of those is the case, then I'd say sleipnir hit the nail on the head, but that shouldn't be a problem, in that case your program should correctly not iterate over the second set.

-Rob

 

[TheDust]

Yup, skiflyer hit it on the head here. Pretty easy fix, but then, I've been out of PHP for 3 or 4 months now... gotta shake some of this rust off. Thanks a lot guys! Peace.

Respect,
Dust