note 13399 added to function.mysql-fetch-array.php
| From: | poogy21 at hotmail dot com | Date: | Thu, 14 Jun 2001 18:26:43 +0000 |
| Subject: | note 13399 added to function.mysql-fetch-array.php | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-14429@lists.php.net to get a copy of this message | ||
why is it that mysql_fetch_array dies on me when my result fetches 19,000 products ... but is
limited to 10 at a time..
example:
select * from products -- 100,000 lines
where category in (1, 2, ..n) -- 19,000 lines
and description like '%text%' -- 10,000 lines
LIMIT 0, 15 -- 15 lines only! ..
as long as the keyword brings back less then 3000 rows.. then mysql_fetch_array is okay (with a
limit of 15 rows) ..
if it's greater then that... (remember, with a limit of 15 rows)...
then I get..
-----------------------------------------------------------
Warning: Supplied argument is not a valid MySQL result resource in (file src) on line 342
------------------------------------------------------
http://www.php.net/manual/en/function.mysql-fetch-array.php