I Need Help (With.. mysql_fetch_array)

poogy21

I'm building an online shopping cart,
in the front line is a search page that
queries a Mysql result (limited by 0,10 - for 10 rows per query) ...

What I begin to notice is that
my search (regardless of the returned rows) effects my php script.

example: .. if the result queries somwhere
in the range of 1000 products (and remember,
the sql script is limited to 10 rows at a time) the return page brings back the set of rows and displayes them just fine..

but when the query goes through more then 1000 products or so.. then I get this error:

Warning: Supplied argument is not a valid MySQL result resource in ...(my source) on line ...

the line it can not process is the 'while ($printArray = mysql_fetch_array($result))' line.

please help me understand .. and solve this horible problem...

thanxxx a lot! - Poogy.

URL: http://laptopmania.com/new_site/
GOOD SEARCH: 'notebook' (1000 + products)
BAD SEARCH: (in the search page click the 'Computers' link.. on top.

[deleted]

use error checking to find out what is wrong, check out this article:
http://www.xs4all.nl/~vinny/index.html#4

poogy21

Thank you Vincent.
I'll make sure to format my code
in the same manner..

But I'm afraid my question is a bit more complex.

my sql is limited to only 15 rows .. (seed 0, limit 15) .. and returns only 15 rows at
a time.

when the mysql database finds 2703 similar
products, it will display them 15 at a time
(with 'LIMIT 0, 10') .. then 'mysql_fetch_array()' only has to work with 15 rows (to my knowledge) .. and it works just fine.. it will echo all rows and content.

but when the search, apllies to more then 5000 products (still limited by 0, 15) .. 'mysql_fetch_array()' should not see a difference in row count (only 15 rows return. ... in fact even mysql_num_rows() and mysql_affected_rows() will echo '15' as the result.) .. and still 'mysql_fetch_array()' dies on me. ..

please help.. thank you.

vincent wrote:

use error checking to find out what is wrong, check out this article:
http://www.xs4all.nl/~vinny/index.html#4

[deleted]

You say that you get "not a valid result blabla" which means the QUERY failed, not the mysql_fetch_array() or whatever.
Try printing the mysql_error() immediately after executing the query, and it will tell you why the query failed.