upload multiple rows into mysql at once

[spires]

Hi Guys.

 

I'm trying to upload a list, row by row into my database.

 

Basically, I have a list of words that are in an array.

But I can't get them to upload row by row.

 

Example.

array:

blackberry

blackberry pearl

blackberry curve

blackberry 8800

 

Thanks for your help

 

[cooldude832]

you don't "upload" to mysql you "insert"

and without table structure, php structure its hard to decrypt your problems

[spires]

Sorry, Half a sleep. 

 

 

I've got it working now

	foreach ($keyword_array as $keyword) {
		$keyword = trim($keyword);


		$sel_sql = "SELECT * FROM blackberry ORDER BY id DESC";
		$sel_query = mysql_query($sel_sql) or die (mysql_error());
		$count = mysql_num_rows($sel_query);

while($keyword){
		$row = mysql_fetch_array($sel_query);
		$keyID = $row['id'];
}
         $sql = "INSERT INTO blackberry (keywords, code, engine, merchant) VALUES ('$keyword', '$eng$keyID', '$engine', '$merchant')";
         mysql_query($sql) or die (mysql_error());


   $key .= trim($keyword)."<br>";
		}