[gunnerone]

Hi

I am trying to create a project where people can create menus from recipes stored in a database.

I need to somehow create a table with days across the top which are determined from a table in my database:

Code:

DROP TABLE IF EXISTS `days`;
CREATE TABLE IF NOT EXISTS `days` (
  `DayID` int(11) NOT NULL auto_increment,
  `DayName` varchar(255) NOT NULL,
  `DateEntered` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `EventID` int(11) NOT NULL,
  `shortcode` varchar(6) NOT NULL,
  `deliveryDay` tinyint(1) NOT NULL,
  PRIMARY KEY  (`DayID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

I need to get the DayNames that correspond to an EventID (submitted by the user in a form above) and put them across the top of a table and the Mealtime type down the side of the table from this table:

Code:

DROP TABLE IF EXISTS `mealtime`;
CREATE TABLE IF NOT EXISTS `mealtime` (
  `mealtimeID` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`mealtimeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

Can anyone assist me in creating a dynamic table in such a way?

Thanks.

[alxkls]

now to be perfectly honest-im not too sure what you are trying to do, even after i read it... so a nit better explanation would be appreciated... on a side note-why dayname is a varchar 255?!?!? wouldnt it be easier to... you know put them as 1,2,3,4,5,6,7 and use those instead. that will massively improve the db size if it gets big. and even if you are making this is some unheard language-store the names in some array somewhere...

[gunnerone]

More Detail::
I have changed my table structure to his.

weekID is grabbed from another table where it has an ID 1-52 and the week name Week 1-52.

dayID is grabbed from another table where it has an ID 1-7 and the day names monday through sunday.

mealtimeID is the ID of the meal from a meals tables where it has an ID 1-5 and description Breakfast, lunch etc.

recipeID is the ID of the recipe in the recipe table.

Table structure
ID
weekID
dayID
mealtimeID
recipeID

I need to grab the contents of the table with the relevant meals that correspond to the correct criteria. for example it would be laid out like this. The values of the header and sidebar are constant only the items in the middle change.

Code:

                      Monday         Tuesday       Wednesday......
Breakfast             

Lunch....

How would i fill in the blanks of the table above with the recipe title held in the recipe table which has an recipeid which corresponds to the id held in the menu table?

[alxkls]

add a few entries to the database, dump them and upload them somewhere. it's almost impossible to follow someone elses logic if you can't see actual data.