[SOLVED]
Well guys, the problem is solved. I think it was compatibility issues of
PHP and MySQL because I tested it on a
PHP 5 and MySQL 5 webhost (
http://www.whost.in) and got it to work without any hassles.
Thanks Alex for taking the time.
Quote:
Originally Posted by alexgeek
I think the actual function is mysql_num_rows() but from the error you are receiving I'd guess that the query is not be executed.
Where you have: mysql_query( query string); change it to:
- PHP: Select all
mysql_query(querystringhere) or die(mysql_error());
This will show any errors with the query.
Have you put in the right database connection string for your server? The connection for your localhost and the connection for your server will be different no doubt. |
Yes, I confirmed every thing(what you said) including privileges of the MySQL db user. All was correct!