Soheil,
Wednesday, March 27, 2002, 6:45:38 PM, you wrote:
SS> I am trying to extract the data from MySQL based on the month, and day of
SS> the item, and post them on a page.
SS> Something similar to "Today in History"
SS> Here is a partial list of my table:
SS> CREATE TABLE ANNOUNCEMENT (
SS>
From: Soheil Shaghaghi <[EMAIL PROTECTED]>
> SELECT AnnouncementID,Title,DateShown FROM ANNOUNCEMENT WHERE
> DateShown=NOW() ORDER BY DateShown DESC
> ...I only want to look at the month, and the day
SELECT AnnouncementID,Title,DateShown
FROM ANNOUNCEMENT
WHERE substring(DateShown,6,5
Hello everyone.
I am trying to extract the data from MySQL based on the month, and day of
the item, and post them on a page.
Something similar to "Today in History"
Here is a partial list of my table:
CREATE TABLE ANNOUNCEMENT (
AnnouncementID bigint(20) unsigned DEFAULT '0' NOT NULL,
Title va
