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
I would do it this way:
Where
$sel_d = (the day # you want)
$sel_m = (the month # you want)
The where clause would be:
Where (start_month = $sel_m and start_day = $sel_d) and
(end_month = $sel_m and end_day = $sel_d)
Someone else will probably have something more elegant, but I
Though the operators are = and =, not = and =.
Toby
-Original Message-
From: Jim Giner [mailto:jim.gi...@albanyhandball.com]
Sent: Monday, October 17, 2011 1:58 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: SELECT
I would do it this way:
Where
$sel_d = (the day # you want)
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