:( make it work

[slighltywhacked]

Got pretty simple query here

mysql_query("UPDATE list (writeup,email) VALUES ('$writeup','$email')");

put it just dosent want to work, writeup and email are passed through via a form( I made sure they were being passed through ) I also double-checked that those were valid fields in my database. I also mad sure that it is infact connected to the database..and it was....

free for suggestions

thanx
later

[qslack]

Are you checking for errors? I'm not all that familiar with mysql's special syntaxes (I use PostgreSQL now) but your SQL UPDATE syntax seems incorrect.

http://www.compapp.dcu.ie/databases/f288.html has the correct syntax.

[slighltywhacked]

Im pretty sure there are numerous ways of doing it. I have used this method since I begun doin MYSQL, and I have never had any trouble like this before

However, it does seem to be missing the where part.. seen as how Im updating, i guess that would be pretty important

[CyberFuture]

Don't you need a WHERE statement? Otherwise the whole table will be updated.

A couple of things you can try:

Try restating your update query using SET

mysql_query("UPDATE list SET
writeup='$writeup',
email='$email'");

Try doing echo stements for $writeup & $email before you do your query statement to see values are being pass by the form.

Best of Luck

[Alarion]

Update syntax should be:

mysql_query("UPDATE list set writeup = '$writeup, email='$email'"); 

Only insert cluases use the syntax you were attempting. If you are trying to insert a record then use:

mysql_query("INSERT INTO list (writeup,email) VALUES ('$writeup','$email')"); 

And CyberFuture is right, you need to tack a where clause on the end of that update statement or you will update every record in your table, which I am sure is NOT what you want