sql inserting an array

[Nuv]

Hey guys,

 

I am inserting an array in mysql table

 

$num = count($data);
for ($c=0; $c < $num; $c++)
{
$insert = mysql_query("INSERT into `$table` VALUES('$data[$c]')");
}

 

where $data is just an element in a line which will constitute  fields in mysql

 

Just wanted to know if my sql query is right

[p2grace]

Typically you add the field name in the query in which the data is for.

 

<?php
$num = count($data);
for ($c=0; $c < $num; $c++)
{
$insert = mysql_query("INSERT INTO `$table` (`fieldname`) VALUES ('".$data[$c]."')");
}
?>

[Nuv]

I cant as i dont know what that array would be,how many fields will be there

[p2grace]

Couldn't you store the field names in the array as well, or convert the data array to be multidimensional?

[Nuv]

Well  i can but i just want to insert elements into mysql as it comes