create a database view code
drop a database view code
query a database view code
mysql_admin1

HERE ARE SOME USEFUL SQL YOU MAY WANT TO USE

$sql = "CREATE DATABASE PERSONALDETAILS;"
$sql = "CREATE TABLE DETAILS ( EMAIL VARCHAR( 50 ) DEFAULT 'ENTER YOUR EMAIL ADDRESS HERE' NOT NULL NAME VARCHAR( 50 ) DEFAULT 'ENTER YOUR NAME HERE' NOT NULL , AGE VARCHAR( 3 ) DEFAULT NULL, UNIQUE ( EMAIL ) );
$sql = "INSERT INTO details ( EMAIL , NAME , AGE ) VALUES ( 'just.do.it.chris@gmail.com', 'chris', '0' )" ;
$sql="SELECT * FROM details WHERE 1 AND AGE IS 0 LIMIT 0 , 30"

To populate dragdowns from database