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

[Jaxel]

I am trying to do the following:

$this->_getDb()->query("
	INSERT INTO EWRatendo_recurs
		(event_id, event_strtime, event_endtime)
	VALUES
		?
", $recurs);

The value of $recurs is as follows:

('9','1294794000','1294815600'),('9','1295398800','1295420400'),('9','1296003600','1296025200')

Theoretically, this should work shouldn't it? Instead I get the following error:

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]

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