[RESOLVED] Unable to update multiple colums in PHP

dudelondon

Hi Guys,

Using PHP5 and MYSQL

I am having a small problem with updating multiples columns in the same query.
There is a problem coming when I try to run the query. It will not update the table cause because of multiple columns but if I try to update only one column it works fine. Please help me in updating multiples below in the same query. Is there any code structure like brackets or curly braces which I should while updating. Please help. It would be very much appreciated.

      

Code:-1

$subject = $_POST['subject'];
$comment = $_POST['comment'];

$q = "UPDATE messages SET subject = ' ".$subject." ', body = ' ".$comment." ' WHERE messages.message_ID = $msg_ID LIMIT 1;";

Regards
Guy from London

bradgrafelman

There are a couple of issues with your SQL query, but before we talk about those... what is the error message MySQL returns? Can you also output the query string and post it here (so we can see what was actually sent)?

dudelondon

Thanks for looking at my thread but I have resolved my problem.

dudelondon

Sorry forgot to share the solution to my problem. If updating many columns inside one single query than make sure you use special characters `` outside the column name and for variable ' " . $variable_name . " '

Like the code below

 `column_name` ='".$varaible_name."'

Regards
Guy from London

(Will come back again if I get stuck again)