如何在新行中的每个部分插入逗号分隔的字符串到MySQL表中？ [重复]

Question

Possible Duplicate:
Add new row in MYSQL from Comma Separated text in textbox
Insert comma separated records in table

$words = 'word1,word2,word3';

How do i get this data into following structure:

MySQL table:

id    value
 1    word1
 2    word2
 3    word3

What i am thinking of:

$separated = explode(",",$words);
//do some kind of loop
INSERT INTO table (value) VALUES ('$something');

I guess i suck at loops :/

Thanks

Answer 1

$wordArray = explode(",", $words);

$stmt = "INSERT INTO table (column) VALUES ('" . implode("'), ('", $wordArray) . "')";

This will produce:

INSERT INTO table (column) VALUES ('word1'), ('word2'), ('word3')