insert into table using array

nel

:rolleyes: anybody of u can help me?
i want som code to insert array coding in database mysql..where this process to many table and to specified field...
this table name and field name i take from database from select statement....
thanks....

Rodney_H_

I am not sure that I understand you.

So...

Can you use complete sentences and provide the code in question with any error messages that you are getting?

// thanks.

nel

hi..
i want to know how to insert data using array in mysql where the data stored in field given? this field_name i taken from database....
thanks a lot...

nel

hi..
i want to know how to insert data using array in mysql where the data stored in field given? this field_name i taken from database....
thanks a lot...

Installer

nm...triple-posted (!) question

Piranha

I suggest that you do what have already been asked from you in this thread. I doubt it that you will get answers for just posting the same question again without any more information.

nel

i don't understand what are u mean?can u eleborate to me?

cricher

umm....im not quite sure what u mean either, but if its about inserting the same info into 2 different tables just use 2 different sql queries, tis what i did

nel

i have two table.table 1 content of data for examlpe idno, name , and table 2 content of table infomatoin for example table_name(table 1) and field_name. data i took from previous page. so i want to insert this data into table 1. by using information table from table 2 for ex:

                     "insert into table_name (field_name) values data1, data2, data3;"

this data is in array
table 2 info i take from select statement.

i hope u will understand..

Weedpacket

So you have two tables; the first one contains data and the second one contains table structure information about the first one.

Use a select statement to get the table structure information from the second table, and use that when making the insert statement that puts data into the first table.

I've also merged your duplicate questions into one thread, and I suggest you read this. What Installer was talking about is mentioned as the eleventh point in the section titled "Oooh, tell me more!".

And, just a couple of pointers, in English the word "you" has three letters, and sentences start with a capital letter. It's just how it is.

nel

i'm 50% understand..

now, the problem is how i can determine which field i can insert in selected table..
can u give me sample code...

question 2 :

$fields = array('field1','field2','field3');

$data = array($data1,$data2,$data3);

so how i can call this $field and $data because i use array (for) and field(field1, field2,...) i get from database (table 1) while $data1,$data2,.. , i get from post function.

i don't know how to use array in one query for example field1, field2 !
thanks....