Update query

[mysql_query]

$query = "UPDATE roster SET something = '$something' AND something_else = '$something_else' WHERE callsign='$callsign'";

This does not work. Worked fine until I added the "AND something_else = '$something_else' "

What is the proper syntax?

Thanks.

[psy]

$query="UPDATE table SET v1=$v1, v2=$v2 WHERE what=what";

// so in short, turn your 'AND' into a ' , ' //

[MrAlaska]

.
http://www.mysql.com/doc/en/UPDATE.html

6.4.5 UPDATE Syntax

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]

[mysql_query]

Yup, that works. thanks