RE: [PHP] last ten from mysql?
| From: | John Coggeshall | Date: | Thu, 13 Jul 2000 01:42:37 +0000 |
| Subject: | RE: [PHP] last ten from mysql? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-6437@lists.php.net to get a copy of this message | ||
> I could be wrong, but if you do much deleting and inserting of records in
> the database, neither of these will definitely give you the last 10
records.
I don't think that they were two separate methods. Basically what he was
doing was finding the total number of records returned (using num_rows),
subtracting 10 then using a SQL statement to start from $start and retrieve
10 records. Since $start was num_rows() - 10, I don't see how it wouldn't
work...
Maybe I'm wrong.
John