mysql_fetch_array() fails cause an empty query
Posted: Wed Apr 02, 2008 1:03 am
I get several errors using the version 4.07.
For example when I click on this following link
http://192.168.0.5/netjukebox/index.php ... der=artist
I get the follwing error message:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /volume1/web/netjukebox/index.php on line 753
This link, is the link to display the list of the artists with the large pictures. (After performing a search by name in the media panel)
I tried to debug to understand from where the problem comes from, and I saw, that the var $query is empty before going into the while loop! (line 753 of the index.php)
I compared the version 5.04 with the version 4.07, and I can say, that the version 5 works like a charm.
The version 4 seems to be unstable. The reason why I use the version 4 instead of the version 5, it is beacause my host does not support the library mysqli. So, I will never be able to install the version 5.
My current running enviornoment is:
- Mysql 5.0.51
- Apache 2.2.3
- PHP 5.2.0
- The operating system is a Linux. (Commercial distribution)
Can you support me about the mysql error?
For example when I click on this following link
http://192.168.0.5/netjukebox/index.php ... der=artist
I get the follwing error message:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /volume1/web/netjukebox/index.php on line 753
This link, is the link to display the list of the artists with the large pictures. (After performing a search by name in the media panel)
I tried to debug to understand from where the problem comes from, and I saw, that the var $query is empty before going into the while loop! (line 753 of the index.php)
I compared the version 5.04 with the version 4.07, and I can say, that the version 5 works like a charm.
The version 4 seems to be unstable. The reason why I use the version 4 instead of the version 5, it is beacause my host does not support the library mysqli. So, I will never be able to install the version 5.
My current running enviornoment is:
- Mysql 5.0.51
- Apache 2.2.3
- PHP 5.2.0
- The operating system is a Linux. (Commercial distribution)
Can you support me about the mysql error?