Hot answers tagged


From what I could see, the query did return a result, but the COALESCE() result was not named, hence MySQL and WordPress use the entire COALESCE() query as the field name. To avoid that, you would use an alias for the COALESCE(), e.g. //$query = "SELECT COALESCE( <your queries> ) AS <alias>"; $query = "SELECT COALESCE( NULL, 5, 2, ...

Only top voted, non community-wiki answers of a minimum length are eligible