根据数组索引将一个数组插入2个表中

Question

I have one array, and it has 10+ indexes.

What I want to do is set variable $table based on the index's, so that it will insert

Array[0] - Array[9] to $table = table1

and it would insert

Array[10] - Array[14] to $table = table2

I don't want to use an if statement because I need them both inserted

I was hoping to keep this all in one query and use $table (if it's possible)

How could I achieve this?

Answer 1

$table = array();

foreach($array as $key => $value)
  if ($key <= 9)
    $table['table1'][$key] = $value;
  else
    $table['table2'][$key] = $value;

This will keep it all as one array. Which I think is kinda what you were going for.

I'm terrible at SQL query so the bellow is just pseudo for if each key is a column in the table:

foreach($table as $key => $value){
    if($key == 'table1'){
        foreach($value as $key => $value){
            //INSERT INTO table1 ($key) VALUES ($value) 
        {
    if($key == 'table2'){
        foreach($value as $key => $value){
            //INSERT INTO table2 ($key) VALUES ($value) 
        {
}