voting help

[Eruondo]

I'm trying to add this in my header, but no matter what I do, it just shows the first result. Could you take a look and tell me if there is anything wrong?

 

$vote = $db->query("SELECT list FROM votes WHERE userid = ".$ir['userid']." ");

if(mysql_num_rows($vote) != trpg)
{
echo "<font color='#FFFFFF'>You haven't voted at TopRPG today! Do it now!</font>

";
}
elseif(mysql_num_rows($vote) != twg)
{
echo "<font color='#FFFFFF'>You haven't voted at TopWebGames today! Do it now!

";
}
elseif(mysql_num_rows($vote) != tpg)
{
echo "<font color='#FFFFFF'>You haven't voted at TopRankinGames today! Do it now!

";
}
elseif(mysql_num_rows($vote) != apex)
{
echo "<font color='#FFFFFF'>You haven't voted at Apex today! Do it now!

";
}
else
{
echo "<font color='#FFFFFF'>You've already voted today.

";
}

[Lithium]

Re: voting help

if

elseif

else

[Eruondo]

Re: voting help

I tried adding a else just now, but I've still got the same problem. Any ideas?

[BlueDevil23]

Re: voting help

mysql_num_rows -

[Lithium]

Re: voting help

as BD23 said... mysql_num_rows() will only return 1/2/3/whatever rows there are or FALSE, if you need to check for certain fields (hint: trpg(voting site)) you need at least the mysql_fetch_array(), my advice... check what is what and go from there!