Creating Tables

iceman2g

Can someone help me figure out how to create a table in phpmyadmin. I did it before to add a store comments section to my database but am trying to do it now to add a store polls and store polloptions table. I don't remeber exactly what I did.

Here's the code I was using before when I added the store comment table.

CREATE TABLE ".$prefix."store_comments (
   name varchar(100) NOT NULL,
   product varchar(60) NOT NULL default '',
   stars tinyint(1) DEFAULT '0' NOT NULL,
   status tinyint(1) DEFAULT '0' NOT NULL,
   comments text NOT NULL,
   id int(60) NOT NULL auto_increment,
   PRIMARY KEY (id)

I have another thread going as to why i'd like to create these tables. You can view it here

Thanks for all the help in advance.

jdiver

Something like this:

CREATE TABLE `polls` (
  `poll_id` mediumint(8) unsigned NOT NULL auto_increment,
  `poll_name` varchar(100) NOT NULL default '',
  `poll_question` text NOT NULL,
  PRIMARY KEY  (`vote_id`)
) TYPE=MyISAM;


CREATE TABLE `poll_options` (
  `poll_option_id` tinyint(4) unsigned NOT NULL auto_increment,
  `poll_id` mediumint(8) unsigned NOT NULL default '0',
  `poll_option_text` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`poll_option_id`)
) TYPE=MyISAM;

iceman2g

Thank you for that it really helped me clear up a few things as I didn't understand what why some of the code I wrote wasn't working.

I've created a table in my db to add the date i'd like the date to be "7/07/2004" right now with my current code I get "7072004" is there anyway for me to do this without creating multiple rows and having "/" being echo between each number.

$com_date=date("mdY");

Also what is NULL and auto_increment?

Thanks in advance

Update:I've been able to get the time to show up as 2004-07-07 by using datetime instead of int(16) for the column type in mysql.

jdiver

FYI, in response to your first question, you can get the date format you want by doing this:

$com_date=date("m/d/Y");

I wouldn't recommend storing any date info like that in the database though, as it will be a real pain to try to manipulate it if need be.

NULL and NOT NULL is defining whether the field can have a NULL value entered for it. auto_increment means the field (integer) will automatically increment by "1" each time a new record is added to the table. This ensures a unique ID for each record in the table.

Here is some good reading for you: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html