page count not working please check my script

[veluit06]

hi

i done php script for number of page viewers counting but its not working please check my script

 

<?

 

    $hostname = "localhost";

    $dbuser = "root";

    $dbpassword = "";

    $dbname = "counter";

 

$db_link= mysql_connect($hostname, $dbuser, $dbpassword) or die("Unable toconnect to the server!");

 

  mysql_select_db($dbname) or die("Unable to connect to the database");

 

  $sql="select count from visitors_count where page='".$page."'";

 

    $count=0;

 

      $cresult=mysql_query($csql);

 

if(mysql_numrows ($cresult))

{

      $crow=mysql_fetch_row($cresult);

      $count=$crow[0];

 

echo "Visitors:".$count."<br>";

}

 

    $count=$count+1;

 

$usql="update visitors_count set count=".$count." where page='".$page."'";

 

if(!mysql_query($usql))

{

      echo mysql_errno();

      echo mysql_error();

}

 

?>

 

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\link\counter.php on line 18

 

error is coming