INSERT INTO within php for loop

[bhenry]

For some reason I have this for loop which adds to a string that I later will query as an INSERT INTO statement. Here is the code.

 

<?php
$atleastone = "1";
$new = "INSERT INTO hoursworked (name, date, hours) VALUES ";
for ($b = 0; $b < $num; $b++)
{
if ($person[$b][1] != "")
{
$name = $person[$b][1] . " " . $person[$b][2];
$dbhours = $person[$b][3];
$dbdate = $date[2] . "-" . $date[0] . "-" . $date[1];
echo $dbdate, " ", $name, " " , $dbhours, "<br />\n";
if ($atleastone != "1"){$new.=",";}
$new.= "('$name', '$dbdate', '$dbhours')";
$atleastone = "2";
}
}

//need to connect
$host = "localhost";
$user = "root";
$pass = "";
$dbname = "losthours";

$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR />");
mysql_select_db($dbname); 

echo $new;
mysql_query($new);
?>

 

The strange thing is that the result when I echo $new is a valid SQL statement in PHPmyadmin. I can't figure out why it won't post to the db when it is called from the .php file. Please help!

[hitman6003]

http://www.phpfreaks.com/forums/index.php/topic,194542.msg876099.html#msg876099

[Gamic]

date is a reserved word in mysql (as date is a datatype) and so would need `` marks around it (or would need to be renamed something else).