Parse error: syntax error, unexpected T_STRING in C:\wamp\www\upl.php on line 16

[Saranya sankar]

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
  die('Failed to connect to server: ' . mysql_error());
}
mysql_select_db("db1", $con);
 
$row = 1;
if (($handle = fopen("contacts.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: </p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            $query = "INSERT INTO backup ("firstname","number") VALUES ("$data[$c]")";
            mysql_query($query)
        }
    }
 
 //   fclose($handle);
?>

this is a simple code to parse a csv file and upload details into database in mysql using wamp server. it doesn work with parse error being the reason i think. help plsss

[Rabbit]

It's probably your INSERT statement. You have quotes in the field list that shouldn't be there and you have only one value in the value list when you specified two columns.

[Dormilich]

and please do not cross-post your question in different forums. that’s impolite towards the people answering your question.

[Saranya sankar]

@dormilich: yes sir i got that! will follow it.. thank you.