Dear all
I'm trying to create a search function that can check the current day in a calendar
against a mysql database where there is a startdate and enddate and if the date is
there then colour code the cell in the calendar.
I have tried to use the following command
$eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday' BETWEEN startdate
AND enddate;";
The database has an ID - title - startdate - enddate
This seems to work BUT if the date in the database is a single number i.e. 0 to 9 it
cannot dispaly it and also if the startdate or endate is a 10, 20 or 30 it also thinks
that it is a 1, 2or 3
Just in case it helps the full codede for this section is as follows :
/snip
$sql_currentday = "$year-$month-$zz";
$eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday' BETWEEN startdate
AND enddate;";
$eventExec = mysql_query($eventQuery);
while($row = mysql_fetch_array($eventExec)) {
if (strlen($row["title"]) > 0) {
echo "<td bgcolor=\"red\" valign=\"middle\" align=\"center\"><font size=\"1px\"
face=\"Verdana\">$zz</font></td>\n";
$result_found = 1;
/snip
Thanks for any advice.
Ray
