mysql行由where子句计数

Question

look at the database here ---->http://www.tiikoni.com/tis/view/?id=908d940

in the subcommentid rows, value 63 is repeating maximum time itself 7 times

i want to fetch this value in numerical form means like this

maximum rows in subcommentid is 7

i hv tried this

$query=mysqli_query("SELECT * FROM table WHERE where id='63'");
    echo mysqli_num_rows($query);

but

but 63 is a variable so how can a server pre decide that 63 is repeating itself maximum nos

nd look at dix ques too cant get my desire result of max(like)

Answer 1

Try using this query -

$query = mysqli_query("SELECT subcommentid,COUNT(*) as count FROM table GROUP BY subcommentid ORDER BY count DESC;");
$result = mysqli_fetch_array($query);
echo $result['subcommentid'].'<br/>'; //subcomment id
echo $result['count']; // number of rows

If you want all, store in array -

$results = array();
while($row = mysqli_fetch_array($query)) {
    $results[$row['subcommentid']] = $row['count'];
}
echo "<pre>";print_r($results);exit;