superhoops Posted August 27, 2006 Share Posted August 27, 2006 Hi my name is Michael and i have just started working with mysql today. I have a database already and want to add a table to it using sql/php code.Here is the code i have:<?php$con = mysql_connect("db5.awardspace.com:3306","fmpsite_reg","password");if (!$con) { die('Could not connect: ' . mysql_error()); }// Create table in fmpsite_reg databasemysql_select_db("fmpsite_reg", $con);$sql = "CREATE TABLE Market (Player varchar(15),Price varchar(12),Type textPosition textAge int(2)Ka int(2)Ta int(2)Pa int(2)Sa int(2))";mysql_query($sql,$con);?>I have put in the password field password so noone here takes it but i was wondering what is wrong with the code or what i need to do to create the tables as i uploaded this file and went to my database and the table had not been created.Any help will be greatly appreciated.ThanksMichael Quote Link to comment Share on other sites More sharing options...
superhoops Posted August 27, 2006 Author Share Posted August 27, 2006 I have added the line mysql> SHOW TABLES;But the file doesn't show this?I must be doing something wrong???Any help would be much appreicated. Quote Link to comment Share on other sites More sharing options...
superhoops Posted August 27, 2006 Author Share Posted August 27, 2006 Sorted it out. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.