[SOLVED] Run a query for each line?

[papaface]

Hello,

How would I run a query for each line in a text file?

I have this so far but it doesnt work:

<?php

mysql_connect("localhost","xxx","xxx") or die (mysql_error());
mysql_select_db("xxxx") or die (mysql_error());

$filename = "file.txt";
$handle = fopen($filename, "r");
$contents = fread($handle, filesize($filename));
fclose($handle);

foreach($contents as $line_num => $line)
{
mysql_query("insert into cats (category) values ('{$line}')") or die(mysql_error());
}

?>

[papaface]

Got it working.

Thanks