Help getting count from database

[pwesthead]

Hi
Im trying to get a count from a field in my database, the field is called rating, in the field rating ,they could have 4 different ansewers very good,good, bad, very bad. im trying to get the count of very good , i have written some php code but does'nt work
here is the code i'm trying.

<?
$votes = mysql_query(" SELECT count( * ) as rating  FROM vote WHERE rating= 'Very good'  ");

    }
if (!$votes) {
  exit('<p>Error retrieving votes from database!<br />'.
      'Error: ' . mysql_error(). '</p>');
}

while ($count = mysql_fetch_array($votes)) {
$rating = $count['Very good'];
    
    ?> Votes <strong>
      <? $count = $_GET['Very good'];
      echo"<div align=center>".$count['Very good']."</div>";
      ?>

[miggl]

Try this:

<?php
    $r_recordset = mysql_query(" SELECT COUNT(*) AS rating  FROM vote WHERE rating= 'Very good'");
    if (!$r_recordset) {exit('<p>Error retrieving votes from database!<br />' . 'Error: ' . mysql_error() . '</p>');}
    else
    {
        while ($r_row = mysql_fetch_array($r_recordset))
        {
            $rating = $r_row[0];
?>
Votes <strong><?php print($r_row[0]); ?></strong>
<?php
        }
    }
?>

[XRay]

If you use COUNT(*) in your query, you will get just one result and that will be number of votes with rating 'Very Good', which means that you don't need while loop for that, and this can't work.
If you need to show total votes with some rating then:
$votes = mysql_query(" SELECT count( * ) as rating FROM vote WHERE rating= 'Very good' ");

should go... $count = mysql_fetch_assoc($votes); and that will display for example ["rating"] => 6.

[ruba]

I can't understand these lines in ur code

      <? $count = $_GET['Very good']; 
      echo"<div align=center>".$count['Very good']."</div>"; 
      ?>

and

$rating = $count['Very good']; //where is the variable??

I think it must be

      <?   echo"<div align=center>".$count['rating']."</div>";   ?>

[pwesthead]

Hi
thankyou
i used miggl code it worked fine thankyou