SQL
Posted: Thu Jun 27, 2002 10:14 pm
hai,
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";
}
?>
no errors showing and else part is working properly and if part not working any suggestions. that is i can't insert to data into the database
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";
}
?>
no errors showing and else part is working properly and if part not working any suggestions. that is i can't insert to data into the database