View Single Post
09-26-2007, 06:17 PM
#2
Salathe is offline Salathe
Salathe's Avatar
Status: Community Archaeologist
Join date: Jul 2004
Location: Scotland
Expertise: Software Development
Software: vim, PHP
 
Posts: 3,820
iTrader: 25 / 100%
 

Salathe will become famous soon enough

Send a message via MSN to Salathe

  Old

I'm not 100% clear exactly what you're trying to achieve but do you really need to SELECT DISTINCT rather than plain old SELECT?

It sounds like you're wanting to get all of the entries for a particular month but grouped together according to their associated day. You can either bring them all back, and use PHP to 'group' by the day or you can only select one from each day (DISTINCT event_date).