Jump to content


This topic is now archived and is closed to further replies.


Create Tables in Mysql

Recommended Posts

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:

$con = mysql_connect

if (!$con)
  die('Could not connect: ' . mysql_error());
// Create table in fmpsite_reg database
mysql_select_db("fmpsite_reg", $con);
$sql = "CREATE TABLE Market
Player varchar(15),
Price varchar(12),
Type text
Position text
Age int(2)
Ka int(2)
Ta int(2)
Pa int(2)
Sa int(2)

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.


Share this post

Link to post
Share on other sites
I have added the line


But the file doesn't show this?

I must be doing something wrong???

Any help would be much appreicated.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.