php/MySQL insert for multiple records...

[asevie]

Fairly new to html, php etc. I can create rudimentary forms but now I'm trying to add multiple records at a time.

 

How do I make the following a variable?

 

I'd like to have this as my insert...

 

$sql = "INSERT INTO  `somedb` (  `ffid` ,  `email` ,  `sku`) VALUES (  $somenewvariable  )";

 

Where $somenewvariable equals this;

 

' ', 'email1@gmail.com', '408'),
(' ', 'email2@example.com', '400'),
(' ', 'email3@example.com', '412'

 

 I'm missing something very basic, ie back slashes! The variable is turning into something like this;

 

\'\', \'email1@gmail.com\', \'408\'), (\'\', \'email2@gmail.com\', \'400\'

Edited March 23, 2013 by asevie

[mac_gyver]

you must be escaping the actual query statement insted of just the data going into the query statement. the syntax of the query, quotes and such that you add around the data to produce the query, don't get escaped.

[asevie]

you must be escaping the actual query statement insted of just the data going into the query statement. the syntax of the query, quotes and such that you add around the data to produce the query, don't get escaped.

 

 

Thanks for the tip.

Edited March 23, 2013 by asevie