Good point. "Tell me and I forget, show me and I remember, involve me and I understand" Ignatius ____________________________________________ ----- Original Message ----- From: "Snijders, Mark" <Mark.Snijders@atosorigin.com> To: "'Marco Tabini'" <marcot@inicode.com>; "Terry Romine" <eatrom@blazing-trails.com> Cc: <php-db@lists.php.net> Sent: Wednesday, November 06, 2002 4:22 PM Subject: RE: sort by date > why does everybody always gives the answers?? why not a hint, or where to > search that they can learn something about it??? > > > > > > -----Original Message----- > From: Marco Tabini [mailto:marcot@inicode.com] > Sent: woensdag 6 november 2002 16:08 > To: Terry Romine > Cc: php-db@lists.php.net > Subject: Re: sort by date > > > Ok, going out on a limb here... have you tried something like > > select e.id, title, location, address, contact, category, event_time, > urllink, descript, min(event_date) from eventTable e inner join > dateTable d on e.id = d.id group by e.id > > ? > > > Marco > > -- > ------------ > php|architect - The magazine for PHP Professionals > The first monthly worldwide magazine dedicated to PHP programmer > > Come visit us at http://www.phparch.com! > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
