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:
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
30, 2000
2 matches
Mail list logo