Mencipta table MySQL dengan PHP

<?php

// Sambungan ke database
// ----------------------------------
// $conn = dbconnect();

$sql = 'CREATE TABLE `kawasan` (
`kid` TINYINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT,
`kketer` VARCHAR( 150 ) NOT NULL,
`klebar` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
`ktinggi` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
`kmak` MEDIUMINT(7) unsigned NOT NULL default 12288,
PRIMARY KEY ( `kid` )
)';
echo 'Mencipta Jadual: 'kawasan'....';
mysql_query( $sql, $conn );
?>

<?php

// Sambungan ke database
// ----------------------------------
// $conn = dbconnect();

$sql = 'DROP TABLE IF EXISTS `kawasan`';
mysql_query( $sql, $conn );

$sql = 'CREATE TABLE `kawasan` (
`kid` TINYINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT,
`kketer` VARCHAR( 150 ) NOT NULL,
`klebar` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
`ktinggi` SMALLINT( 3 ) DEFAULT 0 NOT NULL,
`kmak` MEDIUMINT(7) unsigned NOT NULL default 12288,
PRIMARY KEY ( `kid` )
)';
echo 'Mencipta Jadual: 'kawasan'....';
mysql_query( $sql, $conn );

$sql = 'DROP TABLE IF EXISTS `kategori`';
mysql_query( $sql, $conn );

$sql = 'CREATE TABLE `kategori` (
`bid` int(10) NOT NULL default 0,
`cid` int(10) NOT NULL default 0,
PRIMARY KEY ( `bid`, `cid` )
)';
echo 'Mencipta Jadual: 'kategori'....';
mysql_query( $sql, $conn );

?>