sql1="SELECT state FROM tz_send where state ='0' UNION all SELECT state FROM hot_send where state ='0' UNION all SELECT state FROM dsinfo_send where state ='0' UNION all SELECT state FROM tupian_news where state ='0' UNION all SELECT state FROM dy_send where state ='0'" 然后判断结果集合,如果有记录查询显示a图 否则显示b图
有sata字段,我想判断如果5个表中任何一个表中的sata字段有为0的,就显示a图
如果没有则显示b图?再不该数据库的情况下有什么办法,求救啊?
要显示的 a图,b图在那个表中放??
UNION all
SELECT state FROM hot_send where state ='0'
UNION all
SELECT state FROM dsinfo_send where state ='0'
UNION all
SELECT state FROM tupian_news where state ='0'
UNION all
SELECT state FROM dy_send where state ='0'"
然后判断结果集合,如果有记录查询显示a图
否则显示b图