create table

[Anon]

hi all!

i´ve tried to create a table like this:

$conn = mysql_connect(\"$hostname\",\"$username\",\"$passwort\");
$db = mysql_select_db($dbName, $conn);
if(!$db) {
@mysql_create_db($dbName);
mysql_select_db($dbName, $conn);
$test = @(\"CREATE TABLE $table (ID not null auto_increment primary key,...)\");

but it doesn´t work...
i´ve got a new folder \'$dbName\' but no table.

marc

[djg_uk]

Hi Marc,

It looks like you've made a mistake in the IF statement. Remove the NOT operator (!), as the $db pointer should return TRUE and not FALSE.

Regards,

David

[Anon]

even without the if-statement i don´t get a new table. i think there must be something wrong with my 'CREATE TABLE' query.

$conn = mysql_connect($hostname,$username,$passwort);
@mysql_create_db($dbName);
@mysql_select_db($dbName);
@("CREATE TABLE $table (ID not null auto_increment primary key,
ZEIT int(255))");