$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. Tyler ----- 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. > > --WIll > > -- > 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
