$rs_menu = mysql_query("SELECT count(order_generation) AS V_TOTAL_new1 , SUM(size_new) AS V_TOTAL_new , check_status , order_ID FROM genneration_size
WHERE check_status!='2' AND order_ID = ".$spp1_row['order_ID']." AND order_generation IN ('ASD', 'CSD', 'HRG', 'LBG', 'LSD', 'OBD', 'PFR', 'RAL', 'WSG', '$hdata
GROUP BY order_generation");
$qu1=mysql_query($rs_menu) or die(mysql_error());
SELECT count(order_generation) AS V_TOTAL1 , SUM(size_new) AS V_TOTAL , check_status , order_ID FROM genneration_size
WHERE check_status='0' or check_status='1' or check_status='2' AND order_generation IN ('ASD', 'CSD', 'HRG', 'LBG', 'LSD', 'OBD', 'PFR', 'RAL', 'WSG', '$hdata')
GROUP BY order_generation
Code (PHP)
SELECT count(order_generation) AS V_TOTAL_new1 , SUM(size_new) AS V_TOTAL_new , check_status , order_ID FROM genneration_size
WHERE check_status='0' or check_status='1' AND order_generation IN ('ASD', 'CSD', 'HRG', 'LBG', 'LSD', 'OBD', 'PFR', 'RAL', 'WSG', '$hdata')
GROUP BY order_generation