Re: syntax help~~~

Hi.. I just wanna laugh.... really want to laugh .... WUWUAHAHAHAHAHA I have figure out the solution amazingly! here will be the code I am running LoL <? mysql_connect('localhost','coconut','tkming') 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 auto_increment not null, QId int not null, Primary Key (WId) )" ) or die ("Error! Cannot create table !" . mysql_error() ); ?> I separated the query code with the database connection coding LoL after that.. its work! Thanks for everyone who help me :) Regards Kok Ming "Arcadius A." wrote: > Hello ! > We could keep things simpler ... > Why not give a try to this ?: > > $watchlist_query = mysql_query( "Create Table $temp ( WId int Not > Nullauto_increment, QId int not null, Primary Key (WId) )" ) or die ("Error > ! Cannot create table !" . mysql_error() ); > > Hope it would work :o) > > (At least the "mysql_error()" would show you the error code ) > > Arcad > > "Coconut Ming" <coconut@maxis.net.my> wrote in message > news:3B6D32E6.6B47C76E@maxis.net.my... > > 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 > >