text file to mysql

[astralaaron]

i have a text file with a list if data similar to this:TESTz,TESTx,TEST1TESTs,TESTa,TEST2TEST3,TESTv,TEST3TEST5,TEST2,TEST4is there a way to load the text file into a php file, explode at the comma's and insert each row into a mysql table?

[MinusMyThoughts]

You could try something like this:

$data = explode(',',$list_of_info);$numrows = count($data);$sql = 'INSERT INTO table_name VALUES ';$i = 1;foreach($data as $entry) {  $sql .= "('$entry')";  if($i<$numrows)	$sql .= ", ";  $i++;}if(!mysql_query($sql))  die(mysql_error());

That's assuming the data only has one value per entry. If not, it'll be more complicated than that.-Jason