Good point. "Tell me and I forget, show me and I remember, involve me and I understand"
Ignatius ____________________________________________ ----- Original Message ----- From: "Snijders, Mark" <[EMAIL PROTECTED]> To: "'Marco Tabini'" <[EMAIL PROTECTED]>; "Terry Romine" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 4:22 PM Subject: RE: [PHP-DB] 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: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] 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
