$sql="select author, title, chapter from table order by date DESC limit 15";
That's how you'd go about getting the 15 most recent table entries. The
"next 15" thing will require a bit more though.
----- Original Message -----
From: "WIll" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 9:37 PM
Subject: [PHP] Limit 15 where "Newest"
> I am trying to write a limit statement for my database. I want to say
> something like
> $sql="select author, title, chapter from database where last_update =
> "Newest" order by date limit 15";
> My question is how do you say " Newest" in php MySQL?
> And how do you put t link on the bottom of the page that will select the
> next 15 items in the database?
> Thank you.
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php