Agreed. we prove day in and out that the answers are only an email away...why would anyone go a different route. manual? whats a manual? There are some brilliant people on this list, but some equally intelligent people wrote some fine documentation. "Ignatius Reilly" To: "Snijders, Mark" <Mark.Snijders@atosorigin.com>, "'Marco Tabini'" <ignatius.reill <marcot@inicode.com>, "Terry Romine" <eatrom@blazing-trails.com> y@free.fr> cc: <php-db@lists.php.net> Subject: Re: sort by date 11/06/2002 10:29 AM 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php