mysql_num_rows problem

spectacell

$result = (mysql_query("SELECT * FROM users WHERE user_name = '$form_user_name'"));
if (mysql_num_rows($result))

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in register.php on line 32

You see my problem above...

I have a registerpage where people sign up with usename password and so on...This little code above should be able to tell if the user_name is already taken or not. But when I try to register with a user_name that not exist I get this error.

Isn't mysql_num_rows working if the $result is empty? Is there any way to get around this problem?

Best regards
/Emil Hansson

xblue

mysql_num_rows will return 0 if the query is valid but returns 0 results as far as I know. it will display the error message described only if the query failed.

to find out what's wrong, put it like this:

$sql="SELECT * FROM users WHERE user_name = '$form_user_name'";
echo $sql.'<br />';
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result)

spectacell

Thanks!

Now it says no database selected...hmm sounds weird but logic, now I've got something to go on anyway! 🙂

spectacell

$sql="SELECT * FROM users WHERE user_name = '$form_user_name'";
$result = mysql_db_query($DB, $sql) or die(mysql_error());
if (mysql_num_rows($result)) {

ah now it's working! =) Stupid me!

Thanks for the help again!