how to create users mail table

[shadiadiph]

I have tried this several times but to no success can anyone give me an example I am trying to create a mail table but using the username in the table for example the tabel needs to be called usernamemail

 

I can't seem to figure out how to use $username to do it??

[jackpf]

$username = $_COOKIE['Username'];
$sql = mysql_query("SELECT * FROM table_users WHERE Username='$username'");

 

Something like that possibly?

[shadiadiph]

not what i am looking for i am tring to do something like this but don't know if it is possible

 

$createtable ="create table '$username'mail (`mailID` int(11) NOT NULL auto_increment,`subject` varchar(50),`message` varchar(255))";
$resultcreat = my_sql_query($createtable);

 

 

Anyway thanks for the input i am going to sleep hopefully i will think of anyother way around this

[jackpf]

Why not just have one mail table and a column for the username of who owns that message? That's what I have; works pretty well for me.