Hey, > If you are using PostgreSQL, there is a 'connectby' > function (part of > contrib) which will recursively join hierarchical > data where you have > PID --> ID recursive joins. Oracle also has CONNECT > BY built into the > SQL language. I do not know if MySQL natively > supports anything similar > but maybe someone on this list knows the answer to > that.
Nope, using MySql. I have not checked but I doubt MySql has that in 3.23, pretty sure it does not actually. (Could be wrong) > Having a CONNECT BY clause avoids having to do round > trip selects for > each of your sub categories and greatly simplifies > queries, IMHO. Sure sounds like it. Thanks! Ryan ------ - The faulty interface lies between the chair and the keyboard. - Creativity is great, but plagiarism is faster! - Smile, everyone loves a moron. :-) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
