createtable.php

<?php
$result="CREATE TABLE table_name(
name varchar(100) default NULL,
company varchar(100) default NULL,
address varchar(150) default NULL,
suburb varchar(100) default NULL,
city varchar(50) default NULL,
phone varchar(50) default NULL,
category char(2) default NULL,
tariff char(2) default NULL,
ID int(11) unsigned NOT NULL
)";

//connect to server, then test for failure
if(!($dbLink = mysql_connect("mysql_server", "login_name", "login_password")))
{
    print("Failed to connect to database!<br>\n");
    exit();
}
//select database, then test for failure
if(!($dbResult = mysql_query("USE mysql_database", $dbLink)))
{
    print("Can't use the database.<br>\n");
    exit();
}

mysql_query($result) or die(mysql_error());
?>