這是我寫的語法..但不能用...會出現錯誤
if ('coldrug' == null){ SELECT *
FROM medicine
WHERE TCMCName = 'colherb' UNION SELECT * FROM medicine WHERE TCMEName = 'colherb' UNION SELECT * FROM medicine WHERE TCMGName = 'colherb';}
elseif('colherb' == null){ SELECT * FROM medicine WHERE `Western Medicine` = 'coldrug';}
else{ SELECT * FROM medicine WHERE TCMCName in ('colherb') and `Western Medicine` in ('coldrug') UNION SELECT * FROM medicine WHERE TCMEName in ('colherb') and `Western Medicine` in ('coldrug') UNION SELECT * FROM medicine WHERE TCMGName in ('colherb') and `Western Medicine` in ('coldrug');}
