note 2686 deleted from MySQL functions by danbeck
| From: | danbeck@php.net | Date: | Thu, 07 Sep 2000 14:29:24 +0000 |
| Subject: | note 2686 deleted from MySQL functions by danbeck | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-4329@lists.php.net to get a copy of this message | ||
In reference to hoggardb@panix.com's comment that it was better to limit search results
displays on the MySQL side than on the PHP side: I tried to do this with LIMIT as suggested, but
there seems to be no way within MySQL to get the total number of results when doing a LIMIT, so if
you want to tell the user how many results there were and set up a nice NEXT PAGE or other
navigation system, it's not so convenient. I suppose I could make two queries, one just for
getting the number of results, but it seems like this would incur a lot of overhead. But doing it in
PHP has it's own overhead. I'm not sure what is most efficient. --Max