Re: MYSQL Query results in pages
| From: | Matt Matijevich | Date: | Thu, 24 Jun 2004 19:40:39 +0000 |
| Subject: | Re: MYSQL Query results in pages | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-188996@lists.php.net to get a copy of this message | ||
[snip]
Is this right? Is there other efficent way to do it?
What about if data changes (i.e. new records are added) while the user
browses through pages?
[/snip]
on each page do a:
SELECT count(*) FROM table WHERE your_condition
this will give you your total number of results