<?php
$array1 = array(
'1' => array(
'prodid' => 1,
'title' => 'product one',
),
'2' => array(
'prodid' => 2,
'title' => 'product two',
),
'3' => array(
'prodid' => 3,
'title' => 'product three',
),
);
foreach ($array1 as $prodid => $data){
$insert .= "($prodid,'".$data['title']."'),";
}
$insert = substr($insert,0,-1);
echo $insert;
preferences:
39.74 ms | 402 KiB | 5 Q