Page 1 of 1

php numrows

Posted: Thu Jun 27, 2002 10:46 am
by prasadharischandra
this is not working any sugestions!!!


$add_user="insert into usr_info (usr_name,usr_passw,usr_type,usr_location,usr_full_name,usr_address,
usr_contact)values (\"$username\",\"$password\",\"$type\",\"$location\",\"$fname\",\"$address\",\"$contactno\"
)";




$checkuser=mysql_query("select * from usr_info where usr_name='$username'")
or die(mysql_error());
$available=mysql_num_rows($checkuser)
or die(mysql_error());
if ($available==0)
{
mysql_query($add_user) or die(mysql_error());
echo "successfully";}
else{

echo "soory Already Added";

}
?>

Posted: Thu Jun 27, 2002 11:01 am
by twigletmac
What isn't working? Do you get any error messages? It's easier to help if you give more information.

Mac