-first foreach: Have query for selecting data inside foreach, and query for inserting data outside then get the last id.
-second foreach: Both query for selecting and inserting data inside foreach().
I am concern on two of query for inserting not the selecting one.
If I put both insert query inside one foreach(), I can get the last id.
Any idea?
Code: Select all
//first foreach
foreach(){
foreach(){
>>query select
}
}
>>query insert
$foo = msyql_insert_id();
//second foreach
foreach(){
foreach(){
>>query select
>>query insert($foo)
}
}