[SOLVED] Creating MYSQL tables Problem

[winmastergames]

Well Look at the script first

<?php
include 'config.php';
include 'opendb.php';
$dbtoadd = $_GET["user"];

$query  = 'CREATE DATABASE phpcake';
$result = mysql_query($query);

mysql_select_db('swd-dbweb') or die('Cannot select database');

$query = 'CREATE TABLE $dbtoadd( '.
         'cid INT NOT NULL AUTO_INCREMENT, '.
         'cname VARCHAR(20) NOT NULL, '.
         'cemail VARCHAR(50) NOT NULL, '.
         'csubject VARCHAR(30) NOT NULL, '.
         'cmessage TEXT NOT NULL, '.
         'PRIMARY KEY(cid))';

$result = mysql_query($query);

include 'closedb.php';
?>

You wont need Config.php or opendb.php cause thats just connection but as you can see to make the Table you will have to type script.php?user=tablename but when it makes it it just makes a database with $dbtoadd there must be a trick to making this work

Please and thanks

[Stooney]

In the following code, you need to use double quotes for php to parse the variables inside the quotes.

 

$query = 'CREATE TABLE $dbtoadd( '.
         'cid INT NOT NULL AUTO_INCREMENT, '.
         'cname VARCHAR(20) NOT NULL, '.
         'cemail VARCHAR(50) NOT NULL, '.
         'csubject VARCHAR(30) NOT NULL, '.
         'cmessage TEXT NOT NULL, '.
         'PRIMARY KEY(cid))';

 

edit: technically you could just do

 

$query= 'CREATE TABLE '.$dbtoadd.'('.

the rest is fine

[winmastergames]

So use

"

instead of

'

Change all of them??

[winmastergames]

Ok that worked thanks very much thanks for fast replie