Reverse while(list(...

mrbaseball34

Is there a way to do this in reverse?

while (list($gameno, $gmdate,
         $hometeam, $homescore, 
         $visitteam, $visitscore)=$db->fetch_row($query))

I am returning the last five records by date from the table
using this clause:

order by gamedate desc LIMIT 5

but want them displayed in ascending date order.

TheDefender

There may be a different way, but how about setting up the query, and then doing a mysql_num_rows, and then using that value to define an offset ($total-5) in your LIMIT clause. That way you can use the query again with the offset and limit, and then use that to do an ASC in your order instead.

mrbaseball34

HUH??? I don't quite understand.

TheDefender

Sorry, I will break it down for you...

// Run a query on an indexed field, so you can get a quick count of the total number of records.
$qry = "SELECT indexed_field FROM table";
$countqry = mysql_query($qry);
$total = mysql_num_rows($countqry);

// Now you can take your $total variable, and use that to set an offset in your LIMIT clause.
$newqry = "SELECT * FROM table ORDER BY gamedate ASC LIMIT ($total-5),5";

Untested, but I believe it should work out OK.