[snip]
Cal_ID | Cal_Date | Cal_Event
1 | 1972-01-01 | A new species of whale was
discovered.
7 | 1898-01-07 | The dodo was declared extinct.
8 | 1972-01-08 | The first Earth Day was observed.
Then I used this script to try to display a sample:
<?php
$date = date("Y-m-d");
$sql = "SELECT Cal_Event FROM gzcalendar WHERE
Cal_Date = '$date'";
$res = mysql_query($sql);
while($row = mysql_fetch_assoc($res))
{
print($row['Cal_Event'] . "<br />");
}
?>
$monthDay = date("m-d");
$sql = "SELECT Cal_Event FROM gzcalendar WHERE SUBSTRING(Cal_Date, 6, 5)
= '$monthDay'";
CAUTION! MySQL SUBSTRINGs start counting strings at '1', PHP and othe
langauges usually count from '0'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
