Re: Syntax Eyes
| From: | Morten Winkler Jørgensen | Date: | Wed, 25 Jul 2001 06:39:07 +0000 |
| Subject: | Re: Syntax Eyes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-59496@lists.php.net to get a copy of this message | ||
CD> Hey, I need a set of extra eyes:
OK. I'll put on my magic X-ray typ-oh-glasses ;)
CD> $res_id = mysql_query ("update contacts_data set (
CD> description='$description',
CD> data='$data',
CD> filename='$input_file_name',
CD> filesize='$input_file_size',
CD> filetype='$input_file_type'
CD> where uid='$uid'
CD> )");
My glasses suggests that it might be this:
You are writing
UPDATE adf SET (asdf = 'asd', sadf='ert', ..., WHERE uid =
'myuid')
but try moving the WHERE clause outside the parentheses like
UPDATE adf SET (asdf = 'asd', sadf='ert') WHERE uid =
'myuid'
Of cause my glasses might be broken or need a recompile...
Kind regards,
Morten Winkler