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" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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
> >
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
