[thelist] MySQL sub-select with PHP [was: sql cross table exclusion??]

[rudy]

> what other options do I have for implementing
> this sort of iterative sub-select?

hi mike

hey, thanks for the kind words

here are some helpful guidelines:

rule number 1 -- never do in code what the database can do in sql

rule number 2 -- go read rule number 1 again!!


so, your scenario of running a query and saving the results in php would
seem to violate that guideline

why not save the results in a temp table in the database?

then you can use that table to join with other tables for iterative
searches

trust me, the code you have to write in php becomes a lot simpler

complex code is *much* harder to figure out than simple code

especially when you are juggling arrays, structures, session variables, et
cetera

oh, sure, it's easy to *write* -- that's not the hard part

the hard part comes six months down the road when you've forgotten all your
nifty neato code, and have to make a change to it

rudy