On Tue, 2005-07-26 at 13:39 +0100, Mark Rees wrote: > "André Medeiros" <andre.caum@xxxxxxxxx> wrote in message > news:1122379553.3499.14.camel@xxxxxxx > > One thing I didn't quite explain myself well... I'm building this to > > register objects on a permission system. > > > > The SQL weight is heavy as it is, and I want to save queries as much as > > possible. Making two queries to extract information about a project and > > it's parent is not something I'd want to do. I know recursiveness, but > > thanks for the pointers and for the reply :) > > > > Best regards > > I must admit I still don't really get what you are looking for. Does this > query help? > > select c.field1 AS childfield1, > c.field2 AS childfield2, > (etc) > p.field1 AS parentfield1, > p.field2 AS parentfield2, > (etc) > FROM > child AS c > LEFT JOIN > parent AS p > ON c.parent=p.id > > ? > Yeah, that might do, thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
