insert into table

[Anon]

Hi
I'm trying to insert a row into a users table but its not working...It says that the information has been updated but when i go to check the table it doesn't have the new values in it. any help would be much appeciated.

$sql = mysql_query("INSERT INTO wusers (uname, password, email, loc) VALUES ( '$name', '$password' , '$email' , '$location') ");
$result = mysql_query($sql);
if(!result)
{
printf ("update failed");
}
else
{
printf ("Your Information has been updated! Thank you $name!");
}
}
else{\display form

[Anon]

You need a $ infront of result in the if statement.

if(!result)

needs to be

if(!$result)

Try the query modifying the query to:
"INSERT INTO wusers VALUES ('$name', '$password', '$email' , '$location')"

Hope that helps,
Daniel Ice
http://wwww.coderguy.com