Update Query

[Attila]

Someone refresh my memory again please?

$updaterecord = "UPDATE member SET name = '$name', 
SET password = '$password', SET email = '$email', 
SET icq_number = '$icq_number', SET location = '$location', 
SET website = '$website', SET interests = '$interests', 
SET msnname = '$msnname', SET bday_day = '$bday_day',
SET bday_month = '$bday_month', 
SET bday_year = '$bday_year' 
WHERE memberid = '$memberid'";

What am I doing wrong?

Thanks,
Attila

[vig0]

Originally posted by Attila
Someone refresh my memory again please?

$updaterecord = "UPDATE member SET name = '$name', 
SET password = '$password', SET email = '$email', 
SET icq_number = '$icq_number', SET location = '$location', 
SET website = '$website', SET interests = '$interests', 
SET msnname = '$msnname', SET bday_day = '$bday_day',
SET bday_month = '$bday_month', 
SET bday_year = '$bday_year' 
WHERE memberid = '$memberid'";

What am I doing wrong?

Thanks,
Attila [/B]

This may be what you're trying to do.

$updaterecord = "UPDATE member SET name = '$name',
password = '$password', email = '$email',
icq_number = '$icq_number', location = '$location', 
website = '$website', interests = '$interests', 
msnname = '$msnname', bday_day = '$bday_day',
bday_month = '$bday_month', bday_year = '$bday_year' 
WHERE memberid = '$memberid'";

hope this helps.
vig0
😉

[bav]

I think you are forgetting to put "mysql_query" . Your query should look like the following:

$updaterecord = mysql_query("UPDATE member SET name = '$name', 
SET password = '$password', SET email = '$email', 
SET icq_number = '$icq_number', SET location = '$location', 
SET website = '$website', SET interests = '$interests', 
SET msnname = '$msnname', SET bday_day = '$bday_day',
SET bday_month = '$bday_month', 
SET bday_year = '$bday_year' 
WHERE memberid = '$memberid'");

Good luck!!

[cahva]

Bav, that wouldnt work and you propably see your mistake by now 🙂

As vigo wrote, his snippet is correct. U dont have to add SET in every field.

Bav is correct in that mysql_query but it wasnt relevant bcos for example I allways put the query in a variable and THEN use something like $res=mysql_query($updaterecord)

But its a matter of taste 🙂

[bav]

thanx 4 the correction!!

[Attila]

I saw the difference between his and mine....I swear that I did it without a SET at each variable but I must have had something wrong because it wouldn't work.....LOL

But thank you bery much it fixed the problem....I also put it inside a variable because I like doing it like $res=mysql_query($updaterecord).

Thanks to all who have helped me before and who will help me in the future...I am self taught PHP......Scary hun!:p

Thanks,
Attila