Mysql插入查询失败

Question

I'm getting the following error Invalid query: 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 '1683

INSERT INTO `r10_pull`(`id`, `r10_database_id2`, `repName`, `dateRequested`, `addresspulled`, `status`, `emailAddress`, `type`, `streetStartType`, `streetStartName`, `streetStartDir`, `streetStartCiv`, `streetEndType`, `streetEndName`, `streetEndDir`, `streetEndCiv`, `reportNode`, `systemName`) VALUES ('','$r10_database_id2','$rep','$todaysdate','$address','0','$repemail','$type','$street[streetStartType]','$street[streetStartName]','$street[streetStartDir]','$street[streetStartCiv]','$street[streetEndType]','$street[streetEndName]','$street[streetEndDir]','$street[streetEndCiv]','$reportNode','$systemName')

Answer 1

Many typos -
1) Put empty string in place of 1st empty , in values
2) Remove ] from last value
3) Also needed single quotes in string values

You have got 18 column name and now after removing typos got 18 values

INSERT INTO `r10_pull`(`id`, `r10_database_id2`, `repName`, `dateRequested`,   `addresspulled`, `status`, `emailAddress`, `type`, `streetStartType`, `streetStartName`, `streetStartDir`, `streetStartCiv`, `streetEndType`, `streetEndName`, `streetEndDir`, `streetEndCiv`, `reportNode`, `systemName`) 
VALUES ('','$r10_database_id2','$rep','$todaysdate','$address',0,'$repemail','$type','$street[streetStartType]','$street[streetStartName]','$street[streetStartDir]','$street[streetStartCiv]','$street[streetEndType]','$street[streetEndName]','$street[streetEndDir]','$street[streetEndCiv]','$reportNode','$systemName')

Suggestions: Above is the direct answer to your question. Still avoid using mysql_* function as they are deprecated. Learn mysqli or PDO and start implementing.

Using mysqli_* prepared function -

$mysqli = new mysqli('localhost', 'user', 'password', 'mysampledb');

/* check connection */
if (mysqli_connect_errno()) {
   printf("Connect failed: %s
", mysqli_connect_error());
   exit();
}

$stmt = $mysqli->prepare("INSERT INTO `r10_pull` (`id`, `r10_database_id2`, `repName`, `dateRequested`,   `addresspulled`, `status`, `emailAddress`, `type`, `streetStartType`, `streetStartName`, `streetStartDir`, `streetStartCiv`, `streetEndType`, `streetEndName`, `streetEndDir`, `streetEndCiv`, `reportNode`, `systemName`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
$stmt->bind_param('ssssssssssssssssss', <-- all 18 variables with comma seperated-->);   // bind $sample to the parameter

/* execute prepared statement */  
$stmt->execute();

printf("%d Row inserted.
", $stmt->affected_rows);

/* close statement and connection */
$stmt->close();

/* close connection */
$mysqli->close();