Mark Armendariz wrote:
Nested-set grows rather hairy in no time, especially with data that
needs to be changed often. After some reading (thanks to Elliotte's
compass - thank you sir), it seems to me XML could definitely prove a
better means of tracking hierarchal information, which especiall
Kenneth Downs wrote:
The bit of SQL you need to make it child's play is the "WITH RECURSE"
feature, which is sadly not widely supported:
SELECT record_id, text_of_message
FROM messages chd
JOIN messages par ON chd.record_id_par = par.record_id WITH RECURSE
WHERE chd.record_id = $x
T
Mark Armendariz wrote:
csnyder wrote:
On 8/16/07, Dan Cech <[EMAIL PROTECTED]> wrote:
If you're looking for ideas, here is a proof-of-concept I put together
back in 2004 for a system using a modified preorder traversal tree for
threaded messages.
http://clew.phpwerx.net/
he nice thing abou
csnyder wrote:
On 8/16/07, Dan Cech <[EMAIL PROTECTED]> wrote:
If you're looking for ideas, here is a proof-of-concept I put together
back in 2004 for a system using a modified preorder traversal tree for
threaded messages.
http://clew.phpwerx.net/
he nice thing about using some sort of tre
On 8/16/07, Dan Cech <[EMAIL PROTECTED]> wrote:
>
> If you're looking for ideas, here is a proof-of-concept I put together
> back in 2004 for a system using a modified preorder traversal tree for
> threaded messages.
>
> http://clew.phpwerx.net/
>
The Clew meme dates back to 2003, when NYPHP was e
From: "Dan Cech" <[EMAIL PROTECTED]>
To: "NYPHP Talk"
Sent: Thursday, August 16, 2007 10:53 AM
Subject: Re: [nyphp-talk] XML Manipulation
Ben Sgro (ProjectSkyLine) wrote:
Hello all,
After the XML vs SQL conversation, I started to rethink a product I'
Ben Sgro (ProjectSkyLine) wrote:
> Hello all,
>
> After the XML vs SQL conversation, I started to rethink a product I'm working
> on.
> I had been having a lot of trouble modeling the data into SQL. It was
> starting to
> look very complicated.
>
> So, I decided I would try to store it in XML
Hello all,
After the XML vs SQL conversation, I started to rethink a product I'm working
on.
I had been having a lot of trouble modeling the data into SQL. It was starting
to
look very complicated.
So, I decided I would try to store it in XML. The data I am storing is messages
w/in a thread,
