Forums
This topic is locked
Update all files with a givin id
Posted 26 May 2004 18:59:18
1
has voted
26 May 2004 18:59:18 Dane Taylor posted:
I would like to update a section and archive it. It works when I use the SQL : UPDATE works SET warchive='2' WHERE aid='9';However when I try in Dreamweave it fails to do all the UPDATES is there something I'm doing wrong?
if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "archive"
) {$updateSQL = sprintf("UPDATE works SET warchive=%s WHERE aid=%s",
GetSQLValueString($HTTP_POST_VARS['aid'], "int"
,GetSQLValueString($HTTP_POST_VARS['select'], "text"
);