[SOLVED] PHP-MySQL sitw not woking on webhost, but works on XAMPP

[RohanShenoy]

Hello people,
I got this strange problem.
I have created a website that does not work with my webhost but works on my local machine when I use XAMPP.

Configuration:
webhost: PHP: 4.4.7 MySQL: 4.1.22 - standard
XAMPP: PHP: 5.2.4 MySQL: 5.0.45

I get the error Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/biology/public_html/demo/register.php on line 9

It amazes me that the site works smooth on my local machine.

Do you think this problem is due to version difference?
If yes, then can someone suggest PHP and MySQL 5 webhosts?

Thank you!

Just in case you need the URL its demo.biologyformhtcet.com!

[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.

[RohanShenoy]

[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.

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!