[SOLVED] How do I count mysql rows with specific data

[pneudralics]

I have a table with 5 rows:

data1

data1

data1

data1

data2

 

I want to count only data1. How can I do that?

 

Tried the below but couldn't get it to work

$select = 'SELECT * FROM data WHERE data=data1';

if ($result = mysql_query ($select)) {
while ($row = mysql_fetch_array ($result)) {
$data1 = $row['data'];
echo "$data1";             
             }
}

[MasterACE14]

$select = 'SELECT COUNT(*) FROM data WHERE data=data1';

 

Regards, ACE

[pneudralics]

The if while result didn't work and I got a 0 for the following:

$count = mysql_query("SELECT COUNT(data) AS countdata1 FROM data WHERE 'data' = '$data1'");
$num = mysql_fetch_array($count);

echo $num['countdata1'];

[JasonLewis]

Why don't you just SELECT * FROM data WHERE data='data1' then use mysql_num_rows to get the number?

[pneudralics]

Why don't you just SELECT * FROM data WHERE data='data1' then use mysql_num_rows to get the number?

 

How would I echo the amount of rows with mysql_num_rows? I know how to echo the field in the while loop but not the number of rows it returns.

[Maq]

Read the link to the manual that ProjectFear provided:

 

$sql = mysql_query("SELECT * FROM data WHERE data = 'data1'");
$num_rows = mysql_num_rows($sql);

echo $num_rows;

[pneudralics]

I get the same thing with mysql_num_rows

Both returns zero.

[pneudralics]

Got it. Thanks for the help.

I had to take the single quotes from the first ip after WHERE.