I'm trying to use a rating system on a site. This is the query and PHP
that I've got:

$ratingquery = "SELECT *, AVG(rating) as avgrating
                                FROM rate
                                WHERE videono = $vidvar
                                GROUP BY videono";
$ratingresult = mysql_query($ratingquery) or die(mysql_error());

while ($rating = mysql_fetch_array($ratingresult))
{
if($rating["avgrating"]>1)
{
print '<img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14" />';
}
if($rating["avgrating"]<1)
{
print '<img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14" />';
}
if($rating["avgrating"]>1&$rating["avgrating"]<2)
{
print '<img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14" />';
}
if($rating["avgrating"]>2&$rating["avgrating"]<3)
{
print '<img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14" />';
}
if($rating["avgrating"]>3&$rating["avgrating"]<4)
{
print '<img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_off.gif" alt="1 Star" width="15" height="14" />';
}
if($rating["avgrating"]>4&$rating["avgrating"]<5)
{
print '<img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14"
/><img src="img/star_on.gif" alt="1 Star" width="15" height="14" />';
}
}




The problem is that it doesn't show anything where the 'print' occurs.
It shows nothing. But, when I remove the if statements, I get a
number. So, the query seems to be working. What am I doing wrong with
the <>?

Reply via email to