[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