Click to See Complete Forum and Search --> : help quick please


lukezweb
01-09-2004, 12:45 PM
<?php } else if ($action == "createboard2") {
if ($_POST['submit']) {
$sql2 = "INSERT INTO `boards` (`id`, `name`, `topics`, `posts`, `lastreply`) VALUES ('".$_POST['boardname']."', '".$_POST['boardname']."', '0', '0', 'N/A')";
mysql_query($sql2);
$sql = 'CREATE TABLE `".$_POST['boardname']."` ( `id` MEDIUMINT NOT NULL AUTO_INCREMENT , `type` TEXT NOT NULL , `threadname` TEXT NOT NULL , `startedby` TEXT NOT NULL , `replys` TEXT NOT NULL ,`lastreply` TEXT NOT NULL , PRIMARY KEY ( `id` ) );';
mysql_query($sql);
}
?>



this has an error in it

Parse error

its in the create table where is it worng?

pyro
01-09-2004, 01:51 PM
Quotes error, at least:

$sql = 'CREATE TABLE `".$_POST['boardname']."`

to ->

$sql = 'CREATE TABLE `'.$_POST['boardname'].'`