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.
$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.