Re: phpMyAdmin: delete table
| From: | Miles Thompson | Date: | Fri, 03 Aug 2001 13:54:05 +0000 |
| Subject: | Re: phpMyAdmin: delete table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11026@lists.php.net to get a copy of this message | ||
Don't know about phpAdmin, but in straight PHP, after you've connected to database, etc.
$sql = "drop table tablename";
$result = mysql_query( $sql );
if you want to test for the table before deleting use
$sql = "drop table if exist tablename";
HTH - Miles
At 03:30 PM 8/3/01 +0200, thomas wrote:
Hi, I'm new to phpMyAdmin but they told me to use this programm to delete a table from my mysql database. I've configured the file and when i try to run phpMyAdmin i can see my database on the left frame, however the right frame doesn't show up at all. (instead there's a download dialog box opening all the time). When i download the file and open it in notepad i get an unreadable set of characters what should i do to delete that table?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net