The code below gives a sintaks error when I'am trying to send path to the db!
Could you please help me solve the problem
Error:
INSERT INTO imloop (', 'image1'') VALUES (','Z:\tmp\phpB8.tmp'')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '', 'image1'') VALUES (','Z:\tmp\phpB8.tmp'')' at line 1
Code:foreach($active_keys as $key) { @move_uploaded_file($_FILES[$fieldname]['tmp_name'][$key], $uploadFilename[$key]) or error('receiving directory insuffiecient permission', $uploadForm); $query_part_1 = ''; $query_part_2 = ''; $i = 1; $query_part_1 .= ", 'image" . $i++ . "'"; $query_part_2 .= ",'" . $uploadFilename[$key]. "'"; $query = "INSERT INTO `imloop` ('" .$query_part_1. "') VALUES ('" .$query_part_2. "')"; mysql_query($query) or exit($query . '<br />' . mysql_error()); mysql_close($connection); }


Reply With Quote
Bookmarks