Determining last row of mysql output?

[Anon]

I am trying to come up with a database scheme to use so that I may dynamically create the array file that HierMenu's uses ( http://www.webreference.com/dhtml/hiermenus/ ). Anyhow, I need to print a different line for the last result to signify the end of the array (comma needs to be omitted). Any way to tell if I am at the last row of the result from the mysql db?

[jcarver]

You could get the total number of rows of your result with:

////////
$nextQuery = "YOUR QUERY HERE";
$result = mysql_query($nextQuery);
$number = mysql_numrows($result);
///////

$number is how many rows you'll have and then when you are looping your results later (best to use a for loop for this one...) you can compare your counter to $number, ie.

/////////////
for($i=1;$i<=$number;$i++) {
//YOUR NORMAL CODE HERE
if($i == $number) {
//YOUR SPECIAL LAST TIME CODE HERE
}
}

[Anon]

I'll give that a try - thanks.