How do i improve this code to make my code less trip to database?

[tav]

I have written a code where i am frequently tripping to database which is kinda awkward, i am using the code to count the number of approves, pending, and spam in comments table.here is my code.\[code\] $query_approved = "SELECT COUNT(*) as approved FROM comments WHERE approve = '1'"; $result_approved = mysql_query($query_approved); $row_approved = mysql_fetch_array($result_approved); $query_unapproved = "SELECT COUNT(*) as unapproved FROM comments WHERE approve = '0'"; $result_unapproved = mysql_query($query_unapproved); $row_unapproved = mysql_fetch_array($result_unapproved); $query_spam = "SELECT COUNT(*) as spam FROM comments WHERE spam = '1'"; $result_spam = mysql_query($query_spam); $row_spam = mysql_fetch_array($result_spam);\[/code\]although that code works fine but it looks ugly. is there anyway to improve that?