Hi, i have been trying for weeks to get this code to work, or atleast to be able to connect to my MySQL DB and create a table. if any one of you can help me please do, my host does not offer support for PHP and i have been lost for a while. here is a sample code that i have used. i have tried a lot of other ones and non of them have worked, please, please help me, I am getting sick of not being able to do anything with my site, thanks.
<?php
mysql_connect("localhost", "oxgames", "password");
mysql_query("USE oxgames");
mysql_query("CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),species VARCHAR(20), sex CHAR(1), birth DATE, death DATE");
mysql_list_tables("oxgames");
?>
<?php
mysql_connect("localhost", "oxgames", "password");
mysql_query("USE oxgames");
mysql_query("CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),species VARCHAR(20), sex CHAR(1), birth DATE, death DATE");
mysql_list_tables("oxgames");
?>