ragazzi xkè mi da ERRORE QUERY con questa sintassi??
Codice PHP:
<html>
<head>
<title>txt to mysql</title>
</head>
<body bgcolor="#C7C7C7">
<center>
<?php
$dbhost="localhost";
$dbuser="root";
$dbpass="";
$database="a";
$conn=mysql_connect($dbhost,$dbuser,$dbpass) or die ("errore connessione");
@mysql_select_db($database) or die( "Unable to select database");
//importazione file
$query='LOAD DATA INFILE "\a.txt" INTO TABLE';
$query.=' tab FIELDS TERMINATED BY ";" LINES';
$query.=' TERMINATED BY "\n";';
$recset=mysql_db_query($database,$query) or die ("errore query");
$numrec=mysql_num_rows($recset);
echo $numrec;
mysql_close($conn);
?>
</body>
</html>