help with MySQL query

[mduran]

Hi,

SQL newbie calling:

I've got this table with bug reports and I would like to select:

month, count(bug_reports_with_status_1), count(bug reports_with_status_<>1)

how do you select the same column twice, each time with different constraints ?
the WHERE option only allows a general constraint for the while selection... ?
Should I include the constraint inside the count() ?

thanks.

[Azazeal]

Shot in the dark, but try using 2 queries.

$query1 = mysql_query("SELECT FROM your_table WHERE burg_reports_status = '1' ");
and
$query2 = mysql_query("SELECT FROM your_table WHERE burg_reports_status <> '1' ");

I am not sure if the <> is valid operator in the query, but try it out.

Then you can return the results in an array from both queries.

[mduran]

Well yeah, I actually thought of using two queries, but the thing is I have to pass this information to a jpgraph script in order to generate charts, and having two queries is kind of messy. I'd prefer to have everything done in one if possible.

Any idea ?

[Lars_Berg]

sum(case when status = 1 then 1 else 0 end),
sum(case when status <> 1 then 1 else 0 end)

[mduran]

Works perfectly. thanks !!