syntax help~~~

From: Date: Sun, 05 Aug 2001 11:49:58 +0000
Subject: syntax help~~~
Groups: php.general 
Request: Send a blank email to php-general+get-61319@lists.php.net to get a copy of this message
Hi I am having the problem in the coding below <? mysql_connect('localhost','123','123') or die ("Unable to connect to SQL Server"); mysql_select_db('Helpwatch') or die ("Unable to select database"); $temp = $username."watch"; $watchlist_query = mysql_query("Create Table "$temp"(WId int Not Null auto_increment, QId int not null, Primary Key (WId));"); ?> So.. in the above coding. I need to create a table. The table name should be a user-define name + "watch" I acquire the $username correctly and the variable $temp is working fine when I try to echo the value of it. Just say. I enter my username as coconut so I wish the mysql query to create a table called coconutwatch but I can't do that.. Because of the syntax error, the coding I have underline is where the parser told me that is an error there. I have playing around with it for 2 hours and more... but I cant solve it.. Anyway help is greatly appreciated. Thanks in advance. Sincerely Kok Ming

« previous php.general (#61319) next »