creating table error

[addie]

hi i run this code in my local computer it works ok but in my web it cant create table anyone know why

code:
<?
require_once'config.php';
MySQL_connect("$host","$login","$pass");
MySQL_select_db("$db") or die("Could not select database 1");

$sql = "CREATE TABLE $hits (
hits int(10) DEFAULT '' NOT NULL,)";
$result = mysql_query($sql);

if ($result) {

echo("<br>$hits table created successfully");

} else {
echo("error when creating table");
}

MySQL_close()
?>

[addie]

is anyone gonna reply ?

[laserlight]

What if you try:

<?php
require_once 'config.php';

mysql_connect($host, $login, $pass);
mysql_select_db($db) or die("Could not select database 1");

$sql = "CREATE TABLE $hits (
	hits INT(10) NOT NULL
	)";
$result = mysql_query($sql);

if ($result) {
	echo "<br>" . $hits . "table created successfully";
} else {
	echo "error when creating table";
}
?>

I suspect the problem lies with
hits int(10) DEFAULT '' NOT NULL,
firstly due to the comma, then since you set a null default with the not null directive.

[addie]

thanks alot
it work

[addie]

hi i got another table now same error like other one before 🙁

<?php
require_once 'config.php';

mysql_connect($host, $login, $pass);
mysql_select_db($db) or die("Could not select database 1");

$sql = "CREATE TABLE list (
username VARCHAR(25) NOT NULL
usermail VARCHAR(255) NOT NULL
subject VARCHAR(255) NOT NULL
message VARCHAR(255) NOT NULL
date VARCHAR(30) NOT NULL
ip VARCHAR(30) NOT NULL
)";
$result = mysql_query($sql);

if ($result) {
echo("<br>$abuse created successfully");

} else {
echo("error when creating table");
}

MySQL_close()
?>

[laserlight]

now the problem is the opposite, you dont have commas as needed.

username VARCHAR(25) NOT NULL,
usermail VARCHAR(255) NOT NULL,
subject VARCHAR(255) NOT NULL,
message VARCHAR(255) NOT NULL,
date VARCHAR(30) NOT NULL,
ip VARCHAR(30) NOT NULL