[thelist] manipulating rows in the result set with PHP help

[rudy]

> I replaced the above select and removed what I had, and the result
> set came back blank.... waaah!

perhaps we should take this off list, it's probably your data that would
cause that

send me data exports so i can build these test tables myself

mysql, right?


> Why do I feel everytime I get close with this it blows up in my face!

you took a while nailing down the data structure, so yeah, the code does
have a tendency to blow up with even slight changes in requirements, e.g.
one-to-one or zero-to-one?  outer join or inner?  menuitems and
subcategories both may belong to categories? categories must have
subcategories? and so on...

... proving once again that a competent data modeller can save you ten times
his normal fee in cost avoidance

cost avoidance?  yup, writing good code, even efficient code, that you have
to throw away...


rudy