Re: [PHP] Using a query to selecting between two dates

I ended up using your simpler version, which came out like this: $contentquery3 = mysql_query("SELECT *, YEAR(date) AS year, YEAR(NOW()) AS now FROM $articlestable WHERE articleSectionID = '$id' AND YEAR(date) = YEAR(NOW()) ORDER BY date DESC") or mysql_die(); Thanks. Mike Don Read wrote: >

RE: [PHP] Using a query to selecting between two dates

On 29-Jul-2001 Mike Gifford wrote: > Hello, > > I've got a number of press releases that I'd like to be able to order by > year. > I'd like everything from this now to a year ago (ie. July 29th, 2000) to be > ordered together and then allow folks to scroll back to the previous year > July > 3