information query question?

Rayn

I am currently using this code

if ($this=mysql_fetch_array($this_db)) {
  do {
  } while ($this=mysql_fetch_array($this_db));
}

now is there a way I can a variable to tell me when it reaches the last loop?

like :

1
2
3
4
5 <- stops at 5?

without using the counting method since that will not interact correctly witht he code if I have inside of it.

Thanks
- Me

_SuperString

if (mysql_num_rows($qry) >0) {
while ($myrow = mysql_fetch_array($qry)) {
echo $myrow["whatever"];
}
}

this will stop once the last record has been reached.

junkie_doodle

hmm.. would this help?

$dummy=1;

if($countOfRecords = mysql_num_rows($query) && $countOfRecords)
{
   while($row=mysql_fetch_array($query) && $dummy++&& $dummy < $countOfRecords)
           {
              //code
            }
//now you have the last record in array $row fetched.. 
//AND while loop HASN'T processed the last record
}

-- Edited some of the comments and divided them into two lines to not to cause horizontal scrolling..

Weedpacket

$numrows=mysql_num_rows($query);
if($numrows)
{   for($i=0; $i<$numrows; ++$i)
    {   $row=mysql_fetch_array($query);
        // Do stuff to $row (number $i)
    }
}
else
{    // No rows returned.
}