MySQL and PHP table not being created

Question

HELP! Code not creating a table, does this look ok? How do you usually debug to find out what is not working in MySQL?

<?php  
// Connect to the file above here  
require "connect_to_mysql.php"; 

$sqlCommand = "CREATE TABLE products (
id INT(11) NOT NULL auto_increment,
product_name VARCHAR(255) NOT NULL,
price VARCHAR(64) NOT NULL, 
details text NOT NULL,
category varchar(64) NOT NULL,
date_added date NOT NULL,
PRIMARY KEY(id),
UNIQUE KEY product_name(product_name),
)";

mysql_query($sqlCommand) or die(mysql_error());
?>

You should use a newer SQL extension (PDO or MySQLi for instance). The mysql extension is deprecated. — Sverri M. Olsen
– Sverri M. Olsen, Commented Feb 2, 2014 at 6:02

AyB · Accepted Answer · 2014-02-02 05:39:53Z

10

The last line doesn't need a comma ,

$sqlCommand = "CREATE TABLE products (
id INT(11) NOT NULL auto_increment,
product_name VARCHAR(255) NOT NULL,
price VARCHAR(64) NOT NULL, 
details text NOT NULL,
category varchar(64) NOT NULL,
date_added date NOT NULL,
PRIMARY KEY(id),
UNIQUE KEY product_name(product_name)
)";

I tried out this code in phpMyAdmin first and found that error ^

answered Feb 2, 2014 at 5:39

AyB

11.6k4 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL and PHP table not being created

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related