Am I an idiot, or is PHP an idot?

[johnsmith153]

If I do this:

 

(1)connect, perform mysql etc.

(2)

while($row = mysql_fetch_array($mysqlRes)) {
echo $row[0]."<br>";
}

everything works

 

However, if after performing mysql etc. I try to do this

while($row = mysql_fetch_array($mysqlRes)) {
echo $row[0]."<br>";
}
while($row = mysql_fetch_array($mysqlRes)) {
echo $row[0]."<br>";
}

//ie perform twice in row - it performs first, but then won't perform second.

 

Is this crazy??

 

How can I get this to work?

[zer0day]

When the first while loop is finished, it's already at the end, so when the second starts, there is nothing to show.  Here's an example:

 

$num = 0;
while($num < 10) {
     echo $num."<br />";
     $num++;
}
while($num < 10) {
     echo $num."<br />";
     $num++;
}

 

If the above code executes, it only shows the first while loop, 0 - 9, and when that loop is finished, $num already equals 9, so the second loop doesn't run.

 

This fixes my example:

 

$num = 0;
while($num < 10) {
     echo $num."<br />";
     $num++;
}
$num = 0;
while($num < 10) {
     echo $num."<br />";
     $num++;
}

 

This should fix your problem:

 

$mysqlRes = mysql_query($query);
while($row = mysql_fetch_array($mysqlRes)) {
echo $row[0]."<br>";
}
$mysqlRes = mysql_query($query);
while($row = mysql_fetch_array($mysqlRes)) {
echo $row[0]."<br>";
}

[PFMaBiSmAd]

Don't wasted time and server resources executing a query again just so that you can access the same result set -

 

http://us2.php.net/mysql_data_seek

[JonnoTheDev]

Yes, put the pointer back to the beginning of the array for your second loop. Do not run the same query twice as zer0day has suggested.

[Daniel0]

By your own given possible answers, you're the idiot

 

mysql_fetch_*() moves the pointer one forward. Eventually the pointer will be at the end in which case those functions will return FALSE.