Thanks - that works great!
--- Jay Blanchard
<[EMAIL PROTECTED]> wrote:
> [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]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
