Merge 3 arrays to insert in one row in db

i have those three arrays for example
$num=array(1,2,3);
$name=array('one','two','three');
$letter=array('m','k','n');

what i want is to loop through all of them and insert them like that:

insert into mydb (field1,field2.field3) values(1,'one','m');
ausge is online now Report Post Edit/Delete Message

 

Yeah my Dear you can do this in php

Let's look how to do this.

$i=0;

while($i<3)
{
$query="insert into yourtable values('$num[$i]','$name[$i]','$letter[$i]')";
$result=mysql_query($query);
$i=$i+1;
}

if($result)
{
echo "Records Successfully Entered";
}
else{
echo mysql_error();
}

This code will do what you want.

Happy Coding...!

 

Thanks for the useful information. Very relevant.

 

i really found it very useful.. thanks..