[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:


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.


var me = tom.pixelmech.webDeveloper();

[Making A Commercial Case for Adopting Web Standards]

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.

More information about the thelist mailing list