Insert MySQL Query not running
Posted: Tue Mar 28, 2006 2:27 pm
Code: Select all
for ($i = 0; $i < count($filename); $i++)
{
mysql_query("INSERT INTO carts (itemname,userid) VALUES (". $filename[$i] .",". $userid .")");
}~RB
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
for ($i = 0; $i < count($filename); $i++)
{
mysql_query("INSERT INTO carts (itemname,userid) VALUES (". $filename[$i] .",". $userid .")");
}Code: Select all
...
mysql_query("INSERT INTO carts (itemname,userid) VALUES (". $filename[$i] .",". $userid .")") or die(mysql_error());
...After more research, it wasn't suppose to be in quotes. It was suppose to be '$filename[$i]','$userid'.feyd wrote:Is $filename[$i] always a number?
Code: Select all
... mysql_query("INSERT INTO carts (itemname,userid) VALUES (". $filename[$i] .",". $userid .")") or die(mysql_error()); ...
Code: Select all
...
mysql_query("INSERT INTO `carts` (`itemname`, `userid`) VALUES ('" . mysql_real_escape_string($filename[$i]) ."', '". intval($userid) ."')") or die(mysql_error());
...