insert into table using array(for)

[nel]

actually i want to insert for example :

"insert in $table_name1 f$ield_name1, $field_name2, $field_name3 values $data1, $data2, $data3";

all this variable i get from select statement for example table & field
and i get from $_Request for example data.

all this variable, i also use array(for statement).

2. $fields = array($field1,$field2,$field3);
   $data = array($data1,$data2,$data3);

how i can use array(for statement) in this array ?

can u give me sample code..

[nnichols]

You could use implode on the arrays -

$fields = array($field1,$field2,$field3);
$data = array($data1,$data2,$data3);

$sql = "INSERT INTO $table_name1 (" . implode(',', $fields) . ") VALUES('" . implode("','", $data) . "')";

You should remember to escape the values properly to avoid sql injection etc