Insert a list of words into a database table.

[easethan]

How would I insert a list of words into a database table?

For example:

this
that
these
those

How would I make each word go into a table as an individual row if I had them in a text file?

[ereptur]

You're going to have iterate through a loop to insert each one as a separate query to the database. Such as:

$word_list = array("this","there","that","then");
foreach($word_list as $word) {
   $query = "INSERT INTO word_list (word_id,word) VALUES (NULL,'$word')";
   $result = mysql_query($query) or die(mysql_error());
}

[easethan]

I was afraid of that, thanks.

[DeltaRho2K]

If you have access to the mysql command likne, you could create a text file. put eah row of words on each individual line and use tab to delimit them.

Then from the mysql command line type:

LOAD DATA LOCAL INFILE "yourfilename.txt" INTO TABLE yourtablename

This loads extremely quick, and you don't have to think about the actual SQL language. Just tab delimit your values, and in they go.

The mySQL manual has good info for how to do this.