where clause not working probably simple answer.

[vnichol]

I think that the code is mostly correct, but it passes through and says that it updated the field, but actually it is not adding any information to the table. My logic may be off, I am really not sure. Any help would be appreciated. Thanks

 

include("include/session.php");

$temp =$session->username; // variable that holds user who is logged in.

$result = mysql_query("SELECT * FROM profile WHERE 'username'='$temp'"); // username is table col with information

if(mysql_num_rows($result)!==0)

{

$sql="INSERT INTO profile (username, fname, lname, age, city, occupation)

VALUES

('$_POST[username]','$_POST[fname]','$_POST[lname]','$_POST[age]','$_POST[city]','$_POST[occupation]')";

echo "1 record added!";}

else

{

$sqlUserExists="update profile set fname = $_POST[fname], lname = $_POST[lname], Age = $_POST[age], city = $_POST[city], occupation = $_POST[occupation] where username = $_POST[‘username’]";

echo "Profile Updated!"; }

?>

[trq]

Field names should not be surrounded in quotes.