Guest Posted February 16, 2012 Share Posted February 16, 2012 Ok, so basically I have every column in the link below to work right and have the data for each column displayed....except for "Person" column. http://trigamer.com/forums/newest.php?fid=1 If you check there, you can see the posts, but not the poster. I'm thinking the 7th line from the bottom is the issue? Below is the PHP code for that section: <!-- list threads--> <?php if($threads) {?> <tbody> <?php while($thread = mysql_fetch_array($threads) ){ #get last user to post $last_user = fetch("SELECT user FROM posts WHERE tid = ".$thread["tid"]." ORDER BY dateline DESC LIMIT 1"); if(!$last_user) $last_user = array(); ?> <tr bgcolor="#202025"> <td class="threadIcon"><img src="/images/posticon.png" /></td> <td class="threadTitle"><a href="replythread.php?tid=<?php echo $thread["tid"];?>"><?php echo $thread["title"];?></a></td> <td class="threadReplies"><font color=white><?php echo $thread["replies"];?></font></td> <td><font color=white><?php echo $last_user[0];?></font></td> <td><font color=white><?php echo date("m-d-Y",$thread["dateline"]);?></font></td> </tr> <?php } ?> </tbody> <?php }?> <!-- //end list threads--> Quote Link to comment https://forums.phpfreaks.com/topic/257146-need-help-please-php-wont-grab-data/ Share on other sites More sharing options...
PaulRyan Posted February 17, 2012 Share Posted February 17, 2012 I think the term "2 birds with 1 stone" might apply here. Check my post on your other topic: http://www.phpfreaks.com/forums/index.php?topic=353913.0 Quote Link to comment https://forums.phpfreaks.com/topic/257146-need-help-please-php-wont-grab-data/#findComment-1318183 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.