• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Err... me = noob... Insert Multiple Rows?

Jaxel

Well-known member
#1
I am trying to do the following:
Code:
$this->_getDb()->query("
	INSERT INTO EWRatendo_recurs
		(event_id, event_strtime, event_endtime)
	VALUES
		?
", $recurs);
The value of $recurs is as follows:
Code:
('9','1294794000','1294815600'),('9','1295398800','1295420400'),('9','1296003600','1296025200')
Theoretically, this should work shouldn't it? Instead I get the following error:
Code:
Mysqli prepare error: 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 '?' at line 4
 

Luke F

Well-known member
#2
MySQLi doesn't work like that - you'd have to escape the data manually rather than using the ? substitution thing