I have a page that has an image on it. My assignment is to:
1. Create a section underneath the image where people may comment on the image. The comments need to include a time stamp, and the only way someone can comment is if they are logged in.
2. Create an SQL table in which this information is saved. I have this, but I know it's not right:
CREATE TABLE comments(
commentid int AUTO_INCREMENT NOT NULL ,
commenttime datetime NOT NULL ,
filename varchar( 200 ) NOT NULL ,
name varchar( 200 ) NOT NULL ,
title varchar( 200 ) NOT NULL ,
body text NOT NULL
);
Thanks if you can help!
1. Create a section underneath the image where people may comment on the image. The comments need to include a time stamp, and the only way someone can comment is if they are logged in.
2. Create an SQL table in which this information is saved. I have this, but I know it's not right:
CREATE TABLE comments(
commentid int AUTO_INCREMENT NOT NULL ,
commenttime datetime NOT NULL ,
filename varchar( 200 ) NOT NULL ,
name varchar( 200 ) NOT NULL ,
title varchar( 200 ) NOT NULL ,
body text NOT NULL
);
Thanks if you can help!