Page 1 of 1

n00b needs mySQL help

Posted: Sat Jul 06, 2002 5:25 pm
by pb2ya
ok, i put this code:

Code: Select all

<?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.... :cry:

Posted: Sat Jul 06, 2002 10:23 pm
by DSM

Code: Select all

<?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); 
?>
should be

Code: Select all

<?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); 
?>
[/url]

Posted: Wed Jul 10, 2002 7:39 am
by PaTTeR
The query string should not end with a semicolon.


Code: Select all

mysql_query("CREATE TABLE users 

( 

ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 

UserName TEXT NOT NULL, 

SignUpDate DATE NOT NULL, 

UserDescription TEXT, 

)", 

"$conn");

Posted: Wed Jul 10, 2002 7:43 am
by PaTTeR
00pS the right code is :


Code: Select all

mysql_query("CREATE TABLE users 

( 

ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 

UserName TEXT NOT NULL, 

SignUpDate DATE NOT NULL, 

UserDescription TEXT

)", 

"$conn");
:D