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]
