Insert each new line as mysql row..

[Anon]

Hello!

I have looked through a lot of topics and in the manual, but couldn't find out how to code this issue. I hope it's possible and that someone might be able to help, thank you!

Purpose of code;
I want to be able to enter information into a < textarea > and then have each new line (from an array) as a row in mysql.

Problem,
I have the code for making the array from all new lines (as seen below), but I can’t figure out how to make the data from the array to the mysql database.

$dbl_comma_separated = preg_replace("/(\015\012)|(\015)|(\012)/","::",$list); $array = explode ("::", $dbl_comma_separated);

I have tried a ‘foreach ($array AS $key => $val)’ followed by a mysql insert query, but with no luck.

Anyone have an idea how to solve this? I hope you understood what I meant :-)

Best regards,
Stephan

[[deleted]]

A fast an quick hack:

suppose your array contains (1,2,3,4,5,6)

and you want to insert this into your table, you could compose the query like this:

$sQuery = "INSERT INTO table (field) VALUES (";
$sQuery .= implode( "),(" , $aArray);
$sQuery .= ")";

echo $sQuery;

[Anon]

ahh! love you man ;-) that was perfect! thank you so much!! ::stephan