You have an error in your SQL syntax; check the manual that corresponds to your

[jaypizzy]

I have been trying to sort out the problem with the following code for the longest time. Any help to understand it would be much appreciated.

thanks

<?php

$sql = "CREATE TABLE $_POST[table_name](";

for ($i=0; $i<count($_POST[field_name]); $i++) {

$sql .=$_POST[field_name][$i]." ".$_POST[field_type][$i];

if ($_POST[field_length][$i] != "") {

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

} else {

$sql .= ",";

}

}

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

$sql .= ")";

?>

[Janus13]

this line:

$sql = "CREATE TABLE $_POST[table_name](";

 

should read something like this:

 

$sql = "CREATE TABLE " . $_POST['table_name'];

 

You dont need the ( either. Try that and see if that fixes it.

[shaymol]

Hi jay

you are using $_POST[table_name] instead of  $_POST['var_name']

try to fix all $_POST variable with quote.

 

i think it should work

 

 

Thanks

ShaymoL