Table-Creation Script HELP!

[Anon]

Can anyone see what's wrong with this, I keep getting can't execute query?

$sql = "CREATE TABLE $table_name (";

for ($i = 0; $i < count($field_name); $i++) {
$sql .= "$field_name[$i] $field_type[$i]";

if ($field_length[$i] !="") {
$sql .= " ($field_length[$i]),";
} else {
$sql .= ",";
}
}

$sql = substr($sql, 0, -1);

$sql .= ")";

$result = @($sql,$connection) or die("Couldn't execute query.");

[Anon]

if you put echo $sql . "<BR>"; before the $result = line you will see it.

Also I think you need
$sql .= $field_name[$i] . " " . $field_type[$i];

$sql .= " (" . $field_length[$i] . "),";

!empty($field_length[$i])