Re: last ten from mysql?
| From: | Mike Bosschaert | Date: | Thu, 13 Jul 2000 13:10:43 +0000 |
| Subject: | Re: last ten from mysql? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-6426@lists.php.net to get a copy of this message | ||
1. get number to start with: $start=mysql_num_rows($result)-10
2. include LIMIT statement in you SQL query: SELECT bla bla FROM bla WHERE bla
bla LIMIT $start, 10
Mike
>I just want to select the last ten rows from a mysql
>database on a php page... what command would i use???