Help with phpMyAdmin! I'm desprate!!!

JAPH

Hi all,

Ok, I'm a very new newbie.

Suffice it to say, I'm having trouble with phpMyAdmin. I haven't found any relavant turotials, thus I have resorted to begging for help here. That said, here are my many troubles:

My object is to create a to do list with a) id; b)date; c)Topic; d)Priority; e) status as variable.

Am i correct in assuming that I should that the priority and status should be VARCHAR? What about date? that said, what do the other types mean?

And how would I have the Id automatically generated?

😕

cahva

CREATE TABLE todo (
id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
date DATETIME NOT NULL ,
topic VARCHAR( 255 ) NOT NULL ,
priority VARCHAR( 255 ) NOT NULL ,
status VARCHAR( 255 ) NOT NULL
);

Run that SQL-query to make the table to your database. I dont want to explain what all the types mean, but for example INT(10) means that it only contains number which lenght is 10. Letters are not allowed. For information of numeric types read http://www.mysql.com/doc/en/Numeric_types.html for more specific info.

You can store dates in many ways, some prefer timestamps. DATETIME stores the date in yyyy-mm-dd hh:mm:ss format. Again, I suggest reading the date-types and meanings from mysql-manual.

VARCHAR is good, if your status and priority doesnt exceed 255 characters. For longer texts use TEXT,MEDIUMTEXT or LONGTEXT.

And how would I have the Id automatically generated?

As you can see from creating the table, there is AUTO_INCREMENT in it. In phpMyAdmin you can choose it from 'Extra' when creating a table or adding a new field.

simon622

Hey,

Dont get too stressed all is very simple.

You are worrying about types don't.
Here is a rundown;

a) id: (Primiary Key)

INT size =11 Check 'Index' and 'Primary' checkboxes
set extra to auto_increment this creates a nice primary key

b)date:

Here you need to decide if you want php to insert the date or have a timestamp (similar to the unix timestamp) created when the record is inserted by mySQL. If this is the case use TIMESTAMP
and leave everything else blank, else use VARCHAR say size 8 and have php generate the date using date() and probably insert as 00/00/00 format.

c)Topic:

If you know all the choices you are going to insert, use set or else use varchar set the size to the maximum the element will ever be.

d)Priority:

Same as above

e)Status:

Same as above

Hope this helps

JAPH

Ahhh, thanks! Looking good.