Using mysql_num_rows with JOIN problem

[Aureole]

Here's a lovely problem for you while I go eat dinner.

 

<?php
$query ="SELECT * FROM replies INNER JOIN members ON members.mem_id=replies.reply_author_id WHERE reply_parent_id='{$t_id}' ORDER BY reply_id ASC";
$result = mysql_query($query) or die(mysql_error());

if(mysql_num_rows($result) == 0) {
// CODE BLOCK 1
}
else {
// CODE BLOCK 2
}
?>

 

There are no replies yet the above is executing CODE BLOCK 2 where it should be executing CODE BLOCK 1, you follow?

[pocobueno1388]

have you tried putting that query in your phpmyadmin to see what it brings up?

[Aureole]

Doesn't matter I realized what it was (I think) while eating Dinner, I'll test it out but I gotta go finish Dinner first.