get most recent 20 entries in a mysql db (by id) but order by id asc.?

cmose

ok, this may be a dolt question but I'm not familiar with a simple mysql query solution to it. To elaborate, I have a table, I want to query that table to always get the most recent 20 entries, my understanding of the way to do that is to query the table order by id desc and limit 20, however, I want to get those results and have them ordered by the resulting id's ascending (I want to preserve the row numbers).

Now, I guess my question is, is there anyway to pull the value of the largest id (e.g., the id of the most recent entry), without having to do a seperate query? The point of this is that I want to maintain the value of the id's pulled but I want to use the resulting query in asc order rather then desc. order. Comments/help appreciated!
thanks

DigitalExpl0it

use limit

<?
$sql = "SELECT * FROM table WHERE field1='1' ORDERBY ID DESC LIMIT 20"
?>

cmose

digital,
thanks for your quick response, your suggestion (if I"m reading it right - which isn't always a given 😉 ) would grab me the most recent 20 items where field = field. I had been able to work that out but what I"m having difficulty getting at is:

I want the most recent 20, to do this I need to orderby id desc, however, I want to use that query by id asc and I'm not quite sure of the best way to do this. I don't want to have to use 2 queries, but for my purposes, I guess I could run a query first that just gets the id number of the most recent item and then run another query that gets everything in the db from that id to that id +19 ordered by asc. Just wondering if there was a more 'artful' way to do that.

thanks again for the quick response!

cmose

ok,
worked that out by just running a seperate query that grabs the most recent and subtracting 19 from that.

on another note - is there anyway that I could figure out the monday of the current week?
e.g.
in psuedo code:

if today is note monday
$date = date of monday of following

week

curious if there is a simple solution to that. To put it in context, I'm trying to put together a scheduling page for a weekly schedule. All the old schedules will be stored and the current one is just the most recent 20 entries in the schedule db. My idea to accessing the past ones is, when a new schedule is created, write the starting row is is inserted at to the "dates" table and have to correlate to a date. Then provide a drop down where one can select the date and that would pull the necessary start id from the 'dates' table to query the schedule table with.

hope that made some sense 😉

thanks much!