Iam使用PHPEXCEL类将数据和柱状图从mysql导出到excel。>$gdg = mysql_query("SELECT a.building_id, b.building_name FROM ticket_open a JOIN m_building("SELECT ifnull(count(ticket_no),0) as jcomp FROM ticket_open WHERE STATUS = 'completed' ANDbuilding
我尝试将空的MySQL值设置为零。我使用了IFNULL,但它不起作用。对不起,我的英语不好。php $qry = mysql_query("SELECT IFNULL(stock_i_h_id,0) FROM other_stock_item_creation where"SELECT IFNULL(stock_i_h_id,0) FROM dpr_stock_item where userId='".stock_it