Dear Ron If only day is required u could add another day condition in the where clause e.g. month(current_date) between and day(current_date) between. i think u require something more than this. So could u pls explain your requirement in a little more detail say what would be the output of the query given by u. When would u consider the start date/month and when the end one. ============ regds amit "The difference between fiction and reality? Fiction has to make sense." On Mon, Oct 17, 2011 at 11:08 PM, Ron Piggott < ron.piggott@xxxxxxxxxxxxxxxxxx> wrote: > > I need help creating a mySQL query that will select the correct > introduction message for a website I am making. The way I have designed the > table I can’t wrap my mind around the SELECT query that will deal with the > day # of the month. > > The part of the SELECT syntax I am struggling with is when the introduction > message is to change mid month. The reason I am struggling with this is > because I haven’t used ‘DATE’ for the column type. The reason I didn’t use > ‘DATE’ is because the same message will be displayed year after year, > depending on the date range. > > What I am storing in the table is the start month # (1 to 12) and day # (1 > to 31) and then the finishing month # (1 to 12) and the finishing day # (1 > to 31) > > Table structure for table `introduction_messages` > -- > > CREATE TABLE IF NOT EXISTS `introduction_messages` ( > `reference` int(2) NOT NULL AUTO_INCREMENT, > `start_month` int(2) NOT NULL, > `start_day` int(2) NOT NULL, > `end_month` int(2) NOT NULL, > `end_day` int(2) NOT NULL, > `theme` varchar(100) NOT NULL, > `message` longtext NOT NULL, > PRIMARY KEY (`reference`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; > > My query so far is: > > SELECT * FROM `introduction_messages` WHERE 11 BETWEEN `start_month` AND > `end_month` > > 11 is for November. 2 rows have been selected: > > Row #1: > `start_month` 9 > `start_day` 16 > `end_month` 11 > `end_day` 15 > > Row #2: > `start_month` 11 > `start_day` 16 > `end_month` 12 > `end_day` 10 > > How do I modify the query to incorporate the day #? > > Ron > > > > > www.TheVerseOfTheDay.info >
