note 2686 deleted from MySQL functions by danbeck

From: 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

« previous php.notes (#4329) next »