phpeveryday.com

For example, we will delete the field position of data_employees table by using this program

<?
//the example of deleting MySQL database field table 
//delete_field.php
mysql_connect("localhost","root","admin");//database connection
mysql_select_db("employees");
$order1 = "ALTER TABLE data_employees DROP position";
$add_field = mysql_db_query("employees", $order1);
if ($add_field){
	echo ("<br><br>Field position succeeds in deleting");
}else{
	echo ("<br><br>Field position fails in deleting");
}
?>