Page 1 of 1

Insert MySQL Query not running

Posted: Tue Mar 28, 2006 2:27 pm
by Red Blaze

Code: Select all

for ($i = 0; $i < count($filename); $i++)
	{
	mysql_query("INSERT INTO carts (itemname,userid) VALUES (". $filename[$i] .",". $userid .")");
	}
It's a loop I'm running, but it doesn't want to work properlly. $filename is a series a checkboxes with the name filename[]. I may be doing something wrong in the mysql_query because nothing gets stored. Where did I do the typo? I tried quotes/no quotes on the variables for $filename[$i] and $userid, but I still don't get any results. No errors, no information stored in the database. Thank you.

~RB

Posted: Tue Mar 28, 2006 2:32 pm
by feyd
Is $filename[$i] always a number?

Code: Select all

...
mysql_query("INSERT INTO carts (itemname,userid) VALUES (". $filename[$i] .",". $userid .")") or die(mysql_error());
...

Posted: Tue Mar 28, 2006 3:00 pm
by Red Blaze
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());
...
After more research, it wasn't suppose to be in quotes. It was suppose to be '$filename[$i]','$userid'.

filename is not a number, it's actually a filename. Userid is always a number, though.

Posted: Tue Mar 28, 2006 4:33 pm
by feyd
there's your problem then.

Code: Select all

...
mysql_query("INSERT INTO `carts` (`itemname`, `userid`) VALUES ('" . mysql_real_escape_string($filename[$i]) ."', '". intval($userid) ."')") or die(mysql_error()); 
...