I have the following:
SELECT q25, COUNT( q25 ) AS count, AVG (q1) AS q1
FROM tresults WHERE id = 'Yes' AND date = 'MARCH2010' AND q25 = '1'
GROUP BY q25
At the moment, the query returns MySQL returned an empty result set (i.e. zero rows).
which is correct - is it possible to get it to return NULL
instead?
OR
Is there a way of dealing with this after the event in PHP, such as:
$resultprev = mysql_query($queryprev);
if($resultprev == ''){
// do something
}