Sorry to hijack the main forum for this. I just had a quick question and time might be an issue.
I'm trying to create a guestbook using PHP/MySQL for a class project. It doesn't have to be anything fancy or overly advanced. I just need to be able to create entries and then display them. The overall PHP should be simple but I'm having some problems creating my mySQL table using phpmyadmin. I'm trying the following:
code:
CREATE TABLE `guestbook` (
`id` INT( 255 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 255 ) NOT NULL ,
`date` VARCHAR( 255 ) NOT NULL ,
`time` VARCHAR( 255 ) NOT NULL ,
`entry` LONGTEXT( 10000 ) NOT NULL ,
`f_color` VARCHAR( 255 ) NOT NULL ,
`b_color` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
)
The error I get is (cut & pasted EXACTLY):
MySQL said:
MySQL said:
quote:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(10000) NOT NULL, `f_color` VARCHAR(255) NOT NULL, `b_color` VA
I don't have a clue what that error means but I'm pretty sure it has to do with the field 'entry'. I wanted to use longtext but I don't know how big that is. Does anyone know what's wrong with this? I'd very much appreciate an answer.
Thanks so much for everyones help!
Jim