Jump to content

Archived

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

superhoops

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:

<?php
$con = mysql_connect

("db5.awardspace.com:3306","fmpsite_reg","password");
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)
)";
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.

Thanks
Michael

Share this post


Link to post
Share on other sites
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.

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.