I used PHP to create a table, and it worked. I then tried to create a second table and this one failed.
<?php
error_reporting(-1);
ini_set('display_errors', true);
$server= "************"; /* Address of database server */
$user="************"; /* Database username */
$password="*********"; /* Database Password */
$database="**********"; /* name of database */
mysql_connect($server,$user,$password) or die ( "<H3>Server unreachable</H3>");
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE two ( id varchar(50) NOT NULL default '', userid varchar(10) NOT NULL default '', ip varchar(20) NOT NULL default '', tm datetime NOT NULL default '0000-00-00 00:00:00', status char(3) NOT NULL default 'ON' ) TYPE=MyISAM;";
mysql_query($query);
mysql_close();
?>
This is identical to what I used to create the first table, but the table does not get created (verified using PHPmyadmin). I suspect the code is not good code, but i am using it to learn, so don’t worry about my feelings if it is a mess.