<?php
#Connect to the Server
$conn = @mysql_connect("localhost", "", "");
#Select the Database
mysql_select_db("guestbook", $conn);
#Send SQL Query
mysql_query("CREATE TABLE users
(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
UserName TEXT NOT NULL,
SignUpDate DATE NOT NULL,
UserDescription TEXT,
);",
"$conn");
#Close Connection
mysql_close($conn);
?>
and it comes out as this:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource
plz help.... i typed that stuff in the mysql program, and it works perfectly....
<?php
#Connect to the Server
$conn = @mysql_connect("localhost", "", "");
#Select the Database
mysql_select_db("guestbook", $conn);
#Send SQL Query
mysql_query("CREATE TABLE users
(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
UserName TEXT NOT NULL,
SignUpDate DATE NOT NULL,
UserDescription TEXT,
);",
"$conn");
#Close Connection
mysql_close($conn);
?>
<?php
#Connect to the Server
$conn = @mysql_connect("localhost", "", "");
#Select the Database
mysql_select_db("guestbook", $conn);
#Send SQL Query
CREATE TABLE 'users'
('ID' INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
'UserName' TEXT NOT NULL,
'SignUpDate' DATE NOT NULL,
'UserDescription' TEXT )
#Close Connection
mysql_close($conn);
?>
mysql_query("CREATE TABLE users
(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
UserName TEXT NOT NULL,
SignUpDate DATE NOT NULL,
UserDescription TEXT,
)",
"$conn");
mysql_query("CREATE TABLE users
(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
UserName TEXT NOT NULL,
SignUpDate DATE NOT NULL,
UserDescription TEXT
)",
"$conn");