[thelist] help with SQL and PHP
Tom Dell'Aringa
pixelmech at yahoo.com
Wed Dec 11 09:58:01 CST 2002
--- rudy <r937 at interlog.com> wrote:
--- based on what Paul Cowen suggested:
> > left outer join menuitem on
> > (coalesce(subcat.category, cat.categoryid) =
> menuitem.categoryid)
>
> might be fun seeing whether that's actually supported... or works
> as
> intended
>
> but i like the way you think!!
Whoo hoo! That worked perfect! I added a few columns to the query and
you can see the SQL and the result here:
http://www.pixelmech.com/test/results.html
Now - can someone explain to me just what coalesce does?
Now I have to figure out the php to display it..I'll give it a crack
on my own first.
Thanks a TON guys.
Tom
=====
var me = tom.pixelmech.webDeveloper();
http://www.pixelmech.com/
http://www.maccaws.com/
[Making A Commercial Case for Adopting Web Standards]
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
More information about the thelist
mailing list