sql

[Anon]

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";

}
?>

[bastien]

try echoing the $add_sql to see if all the data is there and of the correct format in the DB.

what error are you getting?

Bastien