[RESOLVED] Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in

[newbie001]

Hi,

I migrated a website to a new server. When I go to the index page I'm getting the following error.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/development/index.php on line 9

Below is the code:

<?php
session_start();

$selcount = mysql_query("SELECT id FROM count_hits WHERE date=CURDATE()");
if(mysql_num_rows($selcount)>0)
{
$objlogin = mysql_fetch_array($selcount);
mysql_query("UPDATE count_hits SET count=(count+1) WHERE id=" . $objlogin["id"]);
}
else
{
mysql_query("INSERT INTO count_hits (count,date) VALUES (1,CURDATE())");
}

if(isset($SESSION['register']) || isset($SESSION['user']))
{
include('./scripts/updatinguser.php');
}
?>

Any help is appreciated.

[bradgrafelman]

Welcome to PHPBuilder! When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

As for your problem, you need to figure out why the SQL query is failing. You should be checking the return value of [man]mysql_query/man, and if it is boolean false, then you should be using the error message returned by MySQL (e.g. via [man]mysql_error/man) to aid in debugging the failing query.

Also note that you could probably make your code a lot simpler and more efficient by replacing all three queries with a single 'INSERT INTO .. ON DUPLICATE KEY UPDATE' query instead (assuming, of course, that you've properly designed your table with a primary key; if you only want one row per date then your 'id' column is superfluous and should be removed).

[newbie001]

thanks, I'll try it out. Closing thread