Need help in fixing this code

[Bickey]

I'm getting this error when I use the following code. Could someone help me to fix this.

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

 

$result =sprintf("SELECT * FROM my_tbl WHERE username ='%s' || email= '%s'", mysql_real_escape_string($username), mysql_real_escape_string($email));
$resultfin = mysql_query($result);
if (mysql_num_rows ($resultfin) > 0){

 

Thanks,

Bickey.

[fxuser]

try changing

$resultfin = mysql_query($result);

to

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

 

so u can get a msg about the error on your query

[Bickey]

You're the man!

 

Thanks,

Bickey.