Problem in using function mysql_num_rows

[PURU]

hey

 

I HAVE BEEN USING PHP DEV 5.I want to verify username and password with database using function mysql_num_rows but every time i use this function it show s error.So can you help me out.My code is given below.

 

$name = $_POST['name'];

$email = $_POST['email'];   

$username = $_POST['username'];

$password = md5($_POST['password']);

 

 

checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");

 

$username_exist = mysql_num_rows($checkuser);

 

if($username_exist > 0){

    echo "I'm sorry but the username you specified has already been taken.  Please pick another one.";

    unset($username);

    include 'register.html';

    exit();

}

 

 

 

 

 

[DarkWater]

You have no $ in front of checkuser.  Also, what error does it show?

[revraz]

checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");

 

should be

 

$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");

 

[PURU]

I have $ in fron of checker still it is showing error :it says function mysql_num_rows is not valid for mysql

[chacha102]

Are you testing this with a valid user name?

[chacha102]

You might also want to use (to clean your data) a sprintf() to insert the user name.

[rhodesa]

please use the following code and copy/paste the EXACT error displayed:

 

<?php
$name = mysql_real_escape_string($_POST['name']);
$email = mysql_real_escape_string($_POST['email']);
$username = mysql_real_escape_string($_POST['username']);
$password = md5($_POST['password']);

$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'")
  or die(mysql_error());

$username_exist = mysql_num_rows($checkuser);

if($username_exist > 0){
    echo "I'm sorry but the username you specified has already been taken.  Please pick another one.";
    unset($username);
    include 'register.html';
    exit();
}
?>