SQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
prasadharischandra
Forum Commoner
Posts: 57
Joined: Thu May 09, 2002 2:19 am
Location: sri lanka
Contact:

SQL

Post by prasadharischandra »

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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Try:

Code: Select all

$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')";
echo $add_user;
To check that your SQL statement looks like you would expect it to.

Mac
prasadharischandra
Forum Commoner
Posts: 57
Joined: Thu May 09, 2002 2:19 am
Location: sri lanka
Contact:

SQL

Post by prasadharischandra »

twigletmac wrote:Try:

Code: Select all

$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')";
echo $add_user;
To check that your SQL statement looks like you would expect it to.

Mac
prasad: i'' ll try using same code problem is if Mysql_num_rows are not there it will work
User avatar
hob_goblin
Forum Regular
Posts: 978
Joined: Sun Apr 28, 2002 9:53 pm
Contact:

Post by hob_goblin »

try:

Code: Select all

$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 (empty($available)) { 
mysql_query($add_user)
 or die(mysql_error()); 
echo "successfully";
} else { 
echo "sorry, already added."; 
}
Post Reply