PHP mysql table for comments

Question

I am adding comments to a website and thought I would make a simple comments table as follows but it is not working. Must be a typo but I cannot find it despite going over and over it and copying it into a different file and so forth. Also for those familiar with comments are these an adequate number of fields?

$maketable = "CREATE TABLE comments(id INT NOT NULL AUTO_INCREMENT, 
 PRIMARY KEY(id),
 name VARCHAR(30),
 whenadded DATETIME,
 storyid INT,
 comment TEXT,
 show TINYINT(1),
 userid INT)";
mysql_query($maketable);

Leven · Accepted Answer · 2012-04-18 19:52:39Z

2

I think 'show' is a reserved word in mysql. Try 'display' or something else:

$maketable = "CREATE TABLE comments(id INT NOT NULL AUTO_INCREMENT, 
 PRIMARY KEY(id),
 name VARCHAR(30),
 whenadded DATETIME,
 storyid INT,
 comment TEXT,
 display TINYINT(1),
 userid INT)";
mysql_query($maketable);

answered Apr 18, 2012 at 19:52

Leven

5303 silver badges10 bronze badges

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

Comments

JohanB · Accepted Answer · 2012-04-18 19:53:19Z

0

The credentials you are using for your database connection pooling in php should not have create/drop privileges on your database. It is better to use a "sql-tool" like phpmyadmin to do your database design.

One off the advantages are better error messages for debugging purposes?

answered Apr 18, 2012 at 19:53

JohanB

2,1481 gold badge16 silver badges15 bronze badges

2 Comments

user1260310 Over a year ago

How do you disable create/drop in connection string? I do have phpadmin which I am using to look at dbase.

JohanB Over a year ago

You do not disable this in your connection string. You need to change the your database user permissions.

ILker Özcan · Accepted Answer · 2012-04-18 20:03:42Z

0

$maketable ="CREATE TABLE  comments (
id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
name VARCHAR( 30 ) NOT NULL,
whenadded DATETIME,
storyid INT( 10 ),
 comment TEXT,
 display INT(1),
 userid INT ( 10 )
) ENGINE = MYISAM;"
mysql_query($maketable);

answered Apr 18, 2012 at 20:03

ILker Özcan

3464 silver badges12 bronze badges

Comments

Vel · Accepted Answer · 2024-07-04 09:29:08Z

0

have you checked mysql_error?

php.net/mysql_error

and i would move the PRIMARY KEY line to the very bottom of the sql statement.

edited Jul 4, 2024 at 9:29

Vel

9,4286 gold badges42 silver badges71 bronze badges

answered Apr 18, 2012 at 19:53

Hajo

8496 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP mysql table for comments

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related