[SOLVED] if no results do this.....

[runnerjp]

i need to be able to display a message if a users has not posted anything in the forum.... im not sure how to get this right... here is my attempt

 

 <?php $sql = "Select * FROM forumtutorial_posts where author = '$profilename' ORDER BY `showtime` DESC LIMIT 0, 5";
$postsresult = mysql_query($sql) or die("Could not get threads");
while($row = mysql_fetch_assoc($postsresult)) {  echo ' <a id="posts" href="http://www.runningprofiles.com/members/index.php?page=message&forum='.$row['forum'].'&id='.$row['postid'].'&pagenum=last">'.$row['title'].'</a> <br />' ;} [b]if ($postresults < 0)[/b] {echo 'user has yet to make a post.';}?>

[jackpf]

Something like so:

if(mysql_num_rows($postresult) == 0)
{
echo 'You have not made a post...';
}

[runnerjp]

i get Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/runningp/public_html/members/include/profile.php on line 139

user has yet to make a post.

[mmarif4u]

Can you show us the updated code.

[runnerjp]

completed it .... this is what i did!

 

<?php $result = mysql_query("SELECT * FROM pb where uid='".$getuser['ID']."' Order by pb") or die(mysql_error());
$num2 = mysql_num_rows($result);
if($num2 < 1)
    {echo 'what ever';}

[jackpf]

Sick.