user registration script

[avillanu]

I'm in the process of building a user registration script. I would like the script to check the database if the username already exists:

 

$query  = "select * from users where username='$username'";
$result = mysql_query($query);
if ($result->num_rows>0)
{echo 'That username is taken';
   exit;}

 

Unfortunately this does not seem to be working. When I submit a duplicate user, I get a MySQL error rather than getting "That username is taken"

 

My guess is it has to do with:

 

$result->num_rows>0)

 

As my book is based on PHP 5 but PHP 4 is running on my server.

[phpknight]

Try this

 

if (mysql_num_rows($result)>0)

 

[avillanu]

Works thank you

[phpknight]

No problem.