计算列中具有特殊值的行数

Question

I'm trying to count how many rows that have the same value as a variable.

Then I wanna echo out the number that is calculated in the mysql query! Is this possible?

Here is a image of my database:

http://img812.imageshack.us/img812/333/9jr1.png

Sorry for my bad English and if the question is hard to understand (new to this stuff)

Answer 1

Here it is from your old question

$query= "SELECT pic_name, count(pic_name) as count FROM hulebild_likes where pic_name='$bild_id'";

$likesf = mysqli_query($con, $query);
$row=mysqli_fetch_array($likesf);
echo $row['count'];