Help for this page

Select Code to Download


  1. or download this
    my $stmt = 'INSERT INTO contact_form (' . join(',', keys %sql) . ') VA
+LUES (' . join(',', ('?') x keys %sql) . ') ON DUPLICATE KEY UPDATE '
+. join(' = ?, ', keys %sql) . ' = ?';
  2. or download this
    $VAR1 = 'INSERT INTO contact_form (more_info,city,name,address,comment
+s) VALUES (?,?,?,?,?) ON DUPLICATE KEY UPDATE more_info = ?, city = ?
+, name = ?, address = ?, comments = ?';
  3. or download this
    ...for the right syntax to use near ' city = , name = , address = , co
+mments ='
  4. or download this
    ON DUPLICATE KEY UPDATE '
+. join(' = ?, ', keys %sql) . ' = ?'