Changeset 154 for trunk/action.php

Timestamp:

Mar 12, 2009, 12:22:02 PM (16 years ago)

Author:

maron

Message:

oprava SQL u oprav

File:

• trunk/action.php (modified) (1 diff)

trunk/action.php

@@ -36 +36 @@
             $ID = $Database->SQLCommand($sql);
                 while ($Line = mysql_fetch_assoc($ID)) {
-                        $sql = 'UPDATE '.$Table;
+                        $sql = 'UPDATE '.$Table.' SET ';
                         foreach($Group['Items'] as $Item) {
                                 $Column_text = addslashes(str_replace($find,$replace,$Line[$Item['Column']]));
-                                $sql .= ' SET '.$Item['Column'].' = "'.$Column_text.'"';
+                                $sql .= ' '.$Item['Column'].' = "'.$Column_text.'",';
                         }
+                        $sql = substr($sql,0,strlen($sql)-1);
                         $sql .= ' WHERE ID = '.$Line['ID'];
                     $Database->SQLCommand($sql);