Solved: MySQL Help

[lumentec]

All I want to do is create a table called "turns" with columns.. "username", and "turns". I already have a database set up via CPanel... but somehow, I managed to mess it up. Some help please?

<?php
$con = mysql_connect("localhost","game","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("game", $con);
$sql = "CREATE TABLE turns 
(
username varchar(16),
turns varchar(4),
)";
mysql_query($sql,$con);

mysql_close($con);
?>

 

[TheRobatron]

This is the SQL I got using PHPMyAdmin to create the table:

CREATE TABLE `turns` (
`username` VARCHAR( 16 ) NOT NULL ,
`turns` VARCHAR( 4 ) NOT NULL
) ENGINE = MYISAM ;

The rest of your PHP looks fine so maybe it's something to do with the NOT NULL or engine (I'm not an expert on MySQL so I couldn't say). Also do you know when it fails? Is it failing to connect or to execute the query? I'd add

if (!mysql_query($sql, $con)) {
die("Could not execute query");
}

to debug it.

HTH