View Full Version : table...??

03-26-2004, 06:28 PM
I need to create a new table in the blobsy db, naming it tb_blobsy_banlist. Add two fields to this table:
Email [varchar(255), not null]
Msg [varchar(255), not null]

how do i do this??

03-26-2004, 10:51 PM
If this is a "one-time" thing, and you have acces to the db I guess the easiest way is to use phpMyAdmin.

If you want to do it by a script try something like:

$conn_id = mysql_pconnect(ypur_host, ypur_user, your_password) or die(mysql_error());
mysql_select_db(blobsy) or die(mysql_error());

mysql_query("CREATE TABLE tb_blobsy_banlist (

email varchar(255) NOT NULL default '',
msg varchar(255) NOT NULL default '',

);") or die(mysql_error());