单个查询多个SQL查询

Question

I am working on a project where a user can add comments and also hit any post.

Now I have to display the total number of comments and total number of hits and also show whether the user has already hitted that post or not.

So basically I need to do three sql queries for this action:

• one counting comments,
• one for counting hits and
• one for checking whether the user has hitted the post or not.

I wanted to know that if it's possible to reduce these three sql queries into one and reduce the database load?

Any help is appreciated.

$checkifrated=mysql_query("select id from fk_views where (onid='$postid' and hit='hit' and email='$email')");//counting hits
        $checkiffollowing=mysql_query("select id from fk_views where (onid='$postid' and hit='hit' and email='$email')");
 $hitcheck=mysql_num_rows($checkifrated);//checking if already hited or not

$checkifrated=mysql_query("select id from fk_views where (onid='$postid' and comment !='' and email='$email')");//counting comments

Answer 1

This query returns the number of hits and number of nonempty comments.

select ifnull(sum(hit='hit'),0) as hits, ifnull(sum(comment !=''),0) as comments 
  from fk_views where onid='$postid' and email='$email'

Based on the queries you provided I dont think you need to query separately if he is hitted the post, just check in you code if number of hits is > 0