将文本文件解析为mySQL数据库

Question

I want to parse a log file into a table in my database using PHP, but I keep getting an error saying

php parse error, unexpected mysql_select_db command

any ideas??

Here's my code;

<?
$handle = @fopen("NeXposeResults.txt","r");
$conn = mysql_connect("localhost")
mysql_select_db("resultsdb.mwb",$conn);

$values=;

while (!feof($handle))
{
    $buffer = fgets($handle, 4096);
    list ($a,$b,$c)=explode("|",$buffer);
    values.=($a,$b,$c);

    INSERT INTO storage (Description, Severity, Risk Score,)
    VALUES ($a,$b,$c,)
}
?>

Answer 1

You're missing a semicolon on line 3.

$conn = mysql_connect("localhost") should be $conn = mysql_connect("localhost");