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

rudy r937 at interlog.com
Wed Dec 11 13:43:00 CST 2002

> 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...


More information about the thelist mailing list