Ian- The first step would be to insert date/time stamp into each of your records during Insert/Update operations. Here is a link how to insert a DATE/TIME into a MySQL Column http://www.php-scripts.com/php_diary/070700.php3 Cheers, Martin Gainty 001-617-852-7822 ----- Original Message ----- From: "Ian O'Rourke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 18, 2004 8:16 AM Subject: Selecting Articles by Month and Year
> I have a series of article in my database and I want to select them by month > and year. So I want a Selection List to hold values like January, 2004, > etc - put it should really select some sort of key like 01-2004. I should > then be able to use that key to filter articles by 01-2004. > > I'm just a bit unsure about the queries, and how to format queries to: > > Return the January, 2004 for what the list shows... > Return the 01-2004 for the Lists actual section > Do a Select using the 01-2004 > > Currently looking at the DATE FORMAT functions, etc, but any help would be > appreciated? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
