[SOLVED] mysql_num_rows isn't returning anything?

[spiceydog]

I have a simple script that says if mysql_num_rows returns 0 than do something different. Unfortunately it doesn't do anything when mysql_num_rows SHOULD be equalling 0. Here is the relevant part of my code:

        <?php 
$recent = "SELECT * FROM messages WHERE user='$user' GROUP BY poster ORDER BY views DESC LIMIT 0, 5";
$result1 = mysql_query($recent) or die(mysql_error());
while ($row = mysql_fetch_array($result1)){
$date  = $row['date'];
$views  = $row['views'];
$post  = $row['post'];
$countresult1 = mysql_num_rows($result1) or die(mysql_error());
if ($countresult1 == '') {
echo "$gender hasn't posted anything yet.";
}
}
?>

 

Thanks in advance!

[spiceydog]

Fixed! and for all who care the solution was to stick the if statement and mysql_num_rows above the while loop.

[spiceydog]

I really wish I could edit old posts. It would really help. Unfortunately I cant so here is my new problem that derived from my first.

 

So I thought everything worked but it turned out that for some reason my query returns 0 everytime which is weird. Here is my new script:

<?php 
$recent = "SELECT * FROM messages WHERE user='$user' GROUP BY poster ORDER BY date DESC LIMIT 0, 5";
$result1 = mysql_query($recent) or die(mysql_error());
if (mysql_num_rows($result1) == 0) {
echo "$gender hasn't posted anything yet.";
}
else {
while ($row = mysql_fetch_array($result1)){
$post  = $row['post'];
$date  = $row['date'];
?>

[Firestorm3d]

does $user equal anything and if it does, does it exist in the table?

[spiceydog]

It was 5AM.... it was working i just didnt realise there was nothing in the table.