PHP MYSQL issues
Posted: Fri Jul 09, 2010 4:07 pm
While this doesnt produce any errors it doesnt create the table.
Any ideas.
Any ideas.
Code: Select all
$con = mysql_connect("localhost",$dbuser,$dbpassword);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($dbname, $con);
$file = fopen($csvfile,"r");
$data = fgetcsv($file,1000,",");
$sql = 'CREATE TABLE ' . $table . ' (';
$c = count($data) - 1;
for ($i=0; $i<=$c; $i++)
{
if ($i==0)
$sql .= $data[$i] . ' VARCHAR(' . $length . ') NOT NULL, ';
else
$sql .= $data[$i] . ' VARCHAR(' . $length . '), ';
}
$sql .= 'PRIMARY KEY (' . $data[0] . '))';
echo $sql;
mysql_query($sql, $con);
mysql_close($con);