SQL Alter table
Posted: Wed Nov 10, 2004 8:24 am
basically all i need to do is insert a php varible as field in mysql database.
To test it i used a static string, the function is as follows:
mysql_select_db($tNG->databasename, $tNG->connection);
mysql_query("ALTER TABLE tbl_subscribed ADD newField_sbd VARCHAR(255)");
It works once, then then mysql needs to restart before you can make any changes.
Any ideas.
To test it i used a static string, the function is as follows:
mysql_select_db($tNG->databasename, $tNG->connection);
mysql_query("ALTER TABLE tbl_subscribed ADD newField_sbd VARCHAR(255)");
It works once, then then mysql needs to restart before you can make any changes.
Any ideas.