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());