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

[PHP] Using a query to selecting between two dates

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 30, 2000 to July 29th, 1999, etc. Unfortunately I'm