Mysql error...

[Drezard]

Heres the error:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\beta\core\user\user.class.php on line 77

 

Heres the code:

 

73.$query = "SELECT * FROM user_ids WHERE username='$username'";

75. $result = mysql_query($query);
   
   	77. $count = mysql_num_rows($result);

79. if ($count == 1) {

 

whats wrong?

 

Thanks, Daniel

[MadTechie]

as a guess i would say line 73

 

$query = "SELECT * FROM user_ids WHERE username='$username'";

 

is this SQL statment valid ?

[The Bat]

Change

 

$result = mysql_query($query);

 

to:

 

$result = mysql_query($query) or die (mysql_error());

 

and post the output.

[tauchai83]

this is undoubtedly have to deal with your record in DB. it doen't match with your SQL query and thus no valid result is returned. Please post more detail of your php code. Thanks