while loop. Is it the last row?

[nikko50]

Hello🙂

How do I know if the loop is printing the last record returned??

$sql = 'SELECT * FROM ORDERS";
$r = $db-> select($sql);
while($row = $db->get_row($r)) {

echo "$row[id]";

//IF THE LAST RECORD PRINT <INNERHTML> HERE

}

[HalfaBee]

You would need to use mysql_num_rows() before the loop and decrement that value untill you got down to 1.
This would then be the last record.
I assume you want to do something different to the last record.

[gtkatz]

I got similar question:

I have

while($row = $db->get_row()){

CODE

}

But later wanted to add a check if there is image in short_story
something like if (get_img_basic($row['short_story']))

How this can be done? Ideas?
Is it something like while($row = $db->get_row() and (get_img_basic($row['short_story']))){

CODE
}