...

View Full Version : table...??



j2freak
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??

boonzie
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 '',

PRIMARY KEY(email)
);") or die(mysql_error());



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum