Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

if i cant find a result in my db..do this

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.';}?>

Open in new window

0
runnerjp
Asked:
runnerjp
  • 2
1 Solution
 
gamebitsCommented:
<?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");
$num = mysql_num_rows($postresult);

if($num < 1)
    {echo 'user has yet to make a post.';}else{
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 />' ;}
     }
?>
0
 
runnerjpAuthor Commented:
i get Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource  hen it shows  user has yet to make a post. even though i have made sevral
0
 
gamebitsCommented:
Ok I have a typo, replace

$num = mysql_num_rows($postresult);

by

$num = mysql_num_rows($postsresult);
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now