Hello,
how to select only if value is present?
$query = $db->query("select menus.id, menus.name,
case
when panels.id is not null then '1'
end as hiddenpanel
from " . \DB_MENUS . " as menus
left join " . \DB_HIDDENPANELS . " as panels on (menus.id =
panels.menu_id)
where menus.id='" . (int)$id . "'
");
i would like to select hiddenpanel only if there is a corresponding value in
DB_HIDDENPANELS. At the moment i get NULL if there is no corresponding value
in HIDDENPANELS table!
Br
Tanel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
