MySQL errors

[risingdevil]

hi,
im having trouble with my site since the mysql maintenance, i keep getting different MySQL errors, instead of a normal page such as my home page is all out of proportion and missing links with
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dnacomp/public_html/lib/database/mysql.php on line 529

and also getting that on other pages.
also when i click on product links on my webpage, it is missing all the files and products. which where linked to MySQL.

im unaware if MySQL maintenance is still underway.

any help would be appreciated.

Thank you

 

[leafypiggy]

If you coded the system yourself,

check the line mentioned (529) and make sure it has a die statement at the end of it.

liek this:

$result = mysql_num_rows('somedata') or die(MYSQL_ERROR());

Sometimes PHP does that. I'm not sure why. Just something I've known to fix my issues with num_rows.

 

[misson]

You should only use "or die()" for debugging. For production code, you'll need a different approach to error handling. Since that's the whole raison d'etre of exceptions, they're the natural choice. Furthermore, if you're going to do something other than "or die()" for production code, you might as well do it from the start.

 

[garrettroyce]

Without seeing your code, it's hard to pinpoint why you would get such an error, but here is what causes that problem many times:

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

Before trying to pass the result of a query to another function such as mysql_fetch_rows() or mysql_num_rows() you need to make sure that the result isn't FALSE

 

[xav0989]

This error is produced by PHP, not the MySQL server. Make sure that the select query executes correctly. (I am on chopin and I have not problems with MySQL).