Welcome Guest, Not a member yet? Register   Sign In
INSERT BATCH issue
#1

[eluser]behnampmdg3[/eluser]
Hi;
I end up with this:
Code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax



print_r($members_list);
$this->db->insert_batch('TACTIFY_cardDetails', $members_list);

INSERT INTO `tactify_carddetails`
            ()
VALUES      ('MCWEEN.COM',
             'unit 18 5-7 cronin ave mainbeach 4217 Australia',
             '[email protected]',
             'steve',
             'mcqeen'),
            ('MCWEEN.COM',
             'unit 18 5-7 cronin ave mainbeach 4217 Australia',
             '[email protected]',
             'steve',
             'mcqeen')
My array looks like this:
Code:
Array
(
    [0] => Array
        (
            [firstName] => steve
            [lastName] => mcqeen
            [email] => [email protected]
            [addWeblink] => MCWEEN.COM
            [address] => unit 18 5-7 cronin ave mainbeach 4217 Australia
        )

    [1] => Array
        (
            [firstName] => steve
            [lastName] => mcqeen
            [email] => [email protected]
            [addWeblink] => MCWEEN.COM
            [address] => unit 18 5-7 cronin ave mainbeach 4217 Australia
        )
)





Theme © iAndrew 2016 - Forum software by © MyBB