UPDATE values?

[derrick1123]

$q = "UPDATE remember SET ('','$name','$email','$msg','$website','$time') VALUES  (id, name, email, msg, website, time)";

 

Would this be able to work?

 

[Daniel0]

No, they're only in the format field=value. I.e.

UPDATE remember SET name=$name, email=$email [...];

[derrick1123]

UPDATE remember SET msg='$msg', name='$name', email='$email', website='$website', time='$time' WHERE id='$id'

 

^So that should work?

 

EDIT: I see remove the quotes...ok thanks ^.^

[Daniel0]

Well, actually the quotes should be there. I just forgot them in my previous post.

[Lamez]

<?php
mysql_query("UPDATE `table` SET `value` = 'this', `anothervalue` = 'that' WHERE `id` = 'id'");
?>

[derrick1123]

Another question...I didn't think it was worth make a WHOLE new topic for.

 

----

I need it to only show 1 id at a time. How is this possible?

 

[Daniel0]

Append LIMIT 1 to the query.