SQL Update Query Problem

[Anon]

I have the following SQL Update Query:

    $SQL_Exec_String = "UPDATE dbtable SET author = $author AND SET title = $title AND SET summary = $summary".
    " AND SET source = $source AND SET theme1 = $theme1 AND SET theme2 = $theme2 AND SET theme3 = $theme4".
    " AND SET theme5 = $theme5 AND SET organisation = $organisation AND SET organisation2 = $organisation2".
    " AND SET organisation3 = $organisation3 AND SET organisation4 = $organisaation4 AND SET organisation5 = $organisation5".
    " AND SET location = $location AND SET hyperlink = $hyperlink AND SET archive = $archive AND SET synthesis_flag = $synthesis_flag".
    " AND SET update_date = $update_date AND SET entry_date = $entry_date AND SET document_type = $document_tape".
    " AND SET priority = $priority WHERE id = $ids";

Executing it, it returns me the follwoing Error:
Syntax error in UPDATE statement., SQL state 37000

Does anybody spot the Error?

Thanks, Patrick.

[Anon]

I'm not sure if this is the problem, but I always use the following syntax for update statements:-

UPDATE table
SET column1 = value1,
column2 = value2,
column3 = value3
WHERE column4 = value4
AND column5 = value5

This I believe is ANSI standard.

Your syntax using AND SET maybe a MySQL extension I don't know, but I've always used the syntax as I've just described with no problems.

Regards,

chrber

[Anon]

Replace your all the 'and set' with ',' and it should work.

I.e. Query should now read:
UPDATE dbtable SET author = $author, title = $title, summary = $summary etc
WHERE id = $ids

Richard

[parena]

And how about putting quotes around your variables, as well?

[Anon]

Thanks for your help: Here is the full working Query, in case somebody else has the same problem.

$SQL_Exec_String = "UPDATE dbtable SET author = '$author', title = '$title', summary = '$summary',".
" source = '$source', theme1 = '$theme1', theme2 = '$theme2', theme3 = '$theme4',".
" theme5 = '$theme5', organisation = '$organisation', organisation2 = '$organisation2',".
" organisation3 = '$organisation3', organisation4 = '$organisaation4', organisation5 = '$organisation5',".
" location = '$location', hyperlink = '$hyperlink', archive = '$archive', synthesis_flag = '$synthesis_flag',".
" update_date = '$update_date', entry_date = '$entry_date', document_type = '$document_tape',".
" priority = '$priority' WHERE id = $ids";