Mysql $query = Update $variable field quick php question
 

First time using the update command.

Basically trying to change the status from 1 to 2 which works with this query without the $id variable I inserted. Anyone know how I format the $id variable properly in this query?


mysql_select_db($mysql);
$query = 'UPDATE `sms`.`messages_import` SET `timestamp` = NOW(), `status` = \'2\' WHERE `messages_import`.`id` = `"$.id."` LIMIT 1;';


Again I tried a few common variations that I knew of like $id, '$id', etc but nothing seemed to work :(

Mucho appreciatedo

its ".$id."

Thanks :) got it working with '.$id.'

thats a pretty fugly style with all those escapes. The only escape you need is for timestamp which is a reserved keyword
You also don't need LIMIT 1, since the id is unique (in most cases anyway)

When you are running queries you're not sure of, always use this format for the query call (assuming you're using the old style mysql calls):

$result = mysql_query($query) or die(mysql_error() . ", query was $query");

Then not only can you see what the error was, you can see why the query string caused it.