Array/subArray mysql insert

[thales.pereira]

Hi,

 

I have an  2 arrays  ( $match[1] and $match[2] ) with 50+ fields that i need to insert into a database, but im not getting how i could do it. Until now im trying with with the following code:

 

 

$sql="INSERT INTO is_trigger_reference	(triggerName) VALUES ('$match[2][0]')";
mysql_query($sql) or die(mysql_error());

 

But when i check into the db table i  only got:

 

triggername ( field name )
Array[0]      ( data inserted)

 

I know i can set a var to each array ( 40+ ) but i belive there's something more clean than that

 

 

Thanks!

[thales.pereira]

solved with:

 

'".$match[2][0]."'