phpeveryday.com

For example, we will add field "position" with the type of "varchar" and field length of 50 character into data_employees table.

<?
//the example of adding MySQL database field table
//add_field.php

//database connection
mysql_connect("localhost","root","admin");
mysql_select_db("employees");

$order1 = "ALTER TABLE data_employees 
           ADD position varchar(255)";
$add_field = mysql_db_query("employees",$order1);

if ($add_field){
	echo ("<br><br>Field position succeeds in adding");
}else{
	echo ("<br><br>Field position fails in adding");
}
?>