1. 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?

Discussion in 'XenForo Development Discussions' started by Jaxel, Jan 1, 2011.

  1. Jaxel

    Jaxel Well-Known Member

    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
     
  2. Luke F

    Luke F Well-Known Member

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

Share This Page