mysql help ?

[jd2007]

how do i add an array into a MySQL table in the database ? for example i want to add  array (below) into a table named 'fruits'..

 

fruit=array("orange", "apple", "mango", "banana", "papaya", "lemon");

 

i want to add it into the table 'fruits' and automatically assign it a id ?

[cooldude832]

is each value its own field or its own row?

[jd2007]

i want to add it into a column 'myfruits'...

[cooldude832]

didn't exaclty answer it but try this

<?php
foreach ($fruits as $value){
mysql_query(INSERT INTO `mytable` (myfruits) VALUES ($value)) or die(mysql_error());
}
?>

you might be able to (untested) to try

<?php
mysql_query(INSERT INTO `mytable` (myfruits) VALUES($fruit)) or die(mysql_error());
?>