[RESOLVED] UPDATE data in more than one column?

[clubbedougan]

Hi,

I'm trying to update more than one column for the same record.

Any ideas?

I've tried...

$query = "UPDATE listings SET approved = 'N', delete = 'Y', comments = '$comments' WHERE id='$id' AND client_id = '$user_id'";
$result = @mysql_query($query); // Run the Query.

...but no success.

Thank you.

[laserlight]

What is the error message? Remove the @ error control operator and use mysql_error().

[clubbedougan]

Hi.
Thanks for the help.

So make it like this ?

$query = "UPDATE listings SET approved = 'N', delete = 'Y', comments = '$comments' WHERE id='$id' AND client_id = '$user_id'";
$result = mysql_query($query); // Run the Query.
mysql_error();

I outputted the query which looks like this :

UPDATE listings SET approved = 'N', delete = 'Y', comments = 'Cos I want to :)' WHERE id='6' AND client_id = '1'

When placing the query into MyPanl I get:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete = 'Y', comments = 'Cos I want to :)' WHERE id='6' AND client_id = '1'' at line 1

- is 'delete' a keyword?

[laserlight]

- is 'delete' a keyword?

Yes. Quote it with backticks (`) for MySQL.

[clubbedougan]

Brilliant stuff.

Thank you laserlight, very much appreciated.

With me it's either keywords, missing semi-colons or not enough coffee 😉

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.