searls03 Posted August 15, 2011 Share Posted August 15, 2011 ok so I am having trouble showing the proper profile pic next to the proper name. it is showing the currently logged in users pic next to every name. I need to know how to make it so the the proper pic shows next to the proper name. I inserted comments, hopefully you can find them, there are a bunch of ////////////////////////////where my comments start. haha. I hope someone understands what I am saying, cause this is difficult to explain. <?php session_start(); include('dbcon.php'); $username1 = $_SESSION['username']; $name1 = $_SESSION['name']; // set time of last activity $userTime = time(); mysql_query("update `sessions` set `activity` = '$userTime' where username='$username1'"); $inactivityTime = time() - 120; // 2 minutes mysql_query("update `sessions` set `loggedin` = '0' where `activity` < '$inactivityTime' "); $username = $rows['f_name']; $sql = mysql_query("SELECT * from pics WHERE personname='$username'");/////////////////////////////this is where pic is being pulled from while($row = mysql_fetch_array($sql)){ $link123 = $row["link"]; } function checkValues($value) { $value = trim($value); if (get_magic_quotes_gpc()) { $value = stripslashes($value); } $value = strtr($value,array_flip(get_html_translation_table(HTML_ENTITIES))); $value = strip_tags($value); $value = mysql_real_escape_string($value); $value = htmlspecialchars ($value); return $value; } function clickable_link($text = '') { $text = preg_replace('#(script|about|applet|activex|chrome):#is', "\\1:", $text); $ret = ' ' . $text; $ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret); $ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret); $ret = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\">\\2@\\3</a>", $ret); $ret = substr($ret, 1); return $ret; } $next_records = 10; $show_more_button = 0; if(checkValues($_REQUEST['value'])) { $userip = $_SERVER['REMOTE_ADDR']; echo "INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','$name1','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')"; mysql_query("INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','$name1','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')"); $result = mysql_query("SELECT *, UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 1"); } elseif($_REQUEST['show_more_post']) // more posting paging { $next_records = $_REQUEST['show_more_post'] + 10; $result = mysql_query("SELECT *, UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit ".$_REQUEST['show_more_post'].", 10"); $check_res = mysql_query("SELECT * FROM facebook_posts order by p_id desc limit ".$next_records.", 10"); $show_more_button = 0; // button in the end $check_result = mysql_num_rows(@$check_res); if($check_result > 0) { $show_more_button = 1; } } else { $show_more_button = 1; $result = mysql_query("SELECT *, UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 0,10"); } while ($row = mysql_fetch_array($result)) { $comments = mysql_query("SELECT *, UNIX_TIMESTAMP() - date_created AS CommentTimeSpent FROM facebook_posts_comments where post_id = ".$row['p_id']." order by c_id asc"); ?> <div class="friends_area" id="record-<?php echo $row['p_id']?>"> <img src="<?php echo $link123;/////////////////////////////////////////////////////////////////////////////////////////////////////this is the original post, one spot where I am having issues ?>" style="float:left;" width="40" alt="" /> <label style="float:left" class="name"> <b><?php echo $row['f_name'];?></b> <em><?php echo clickable_link($row['post']);?></em> <br clear="all" /> <span> <?php // echo strtotime($row['date_created'],"Y-m-d H:i:s"); $days = floor($row['TimeSpent'] / (60 * 60 * 24)); $remainder = $row['TimeSpent'] % (60 * 60 * 24); $hours = floor($remainder / (60 * 60)); $remainder = $remainder % (60 * 60); $minutes = floor($remainder / 60); $seconds = $remainder % 60; if($days > 0){ echo date('F d Y', $row['date_created']); }else if($days == 0 && $hours == 0 && $minutes == 0){ echo "few seconds ago"; }elseif($days == 0 && $hours == 0){ echo $minutes.' minutes ago'; }else { echo $minutes.' minutes ago';} ?> </span> <a href="javascript: void(0)" id="post_id<?php echo $row['p_id']?>" class="showCommentBox">Comments</a> </label> <?php $userip = $_SERVER['REMOTE_ADDR']; if($row['userip'] == $userip){?> <a href="#" class="delete"> Remove</a> <?php }?> <br clear="all" /> <div id="CommentPosted<?php echo $row['p_id']?>"> <?php $comment_num_row = mysql_num_rows(@$comments); if($comment_num_row > 0) { while ($rows = mysql_fetch_array($comments)) { $days2 = floor($rows['CommentTimeSpent'] / (60 * 60 * 24)); $remainder = $rows['CommentTimeSpent'] % (60 * 60 * 24); $hours = floor($remainder / (60 * 60)); $remainder = $remainder % (60 * 60); $minutes = floor($remainder / 60); $seconds = $remainder % 60; ?> <div class="commentPanel" id="record-<?php echo $rows['c_id'];?>" align="left"> <img src="<?php echo $link123;//////////////////////////////////////////////////////////////////////////////////////////////////////here are comments, one spot where i having issues ?>" width="40" class="CommentImg" style="float:left;" alt="" /> <label class="postedComments" > <strong><font color="#3B5998"> <?php echo $rows['f_name'];?></font></strong> <?php echo clickable_link($rows['comments']);?> </label> <br clear="all" /> <span style="margin-left:43px; color:#666666; font-size:11px"> <?php if($days2 > 0){ echo date('F d Y', $rows['date_created']);} elseif($days2 == 0 && $hours == 0 && $minutes == 0){ echo "few seconds ago"; }elseif($days2 == 0 && $hours == 0){ echo $minutes.' minutes ago'; }else{ echo $minutes.' minutes ago';} ?> </span> <?php $userip = $_SERVER['REMOTE_ADDR']; if($rows['userip'] == $userip){?> <a href="#" id="CID-<?php echo $rows['c_id'];?>" class="c_delete">Delete</a> <?php }?> </div> <?php }?> <?php }?> </div> <div class="commentBox" align="right" id="commentBox-<?php echo $row['p_id'];?>" <?php echo (($comment_num_row) ? '' :'style="display:none"')?> > <label id="record-<?php echo $row['p_id'];?>" > <textarea class="commentMark" id="commentMark-<?php echo $row['p_id'];?>" name="commentMark" cols="60"></textarea> </label> <br clear="all" /> <a id="SubmitComment" class="small button comment"> Comment</a> </div> </div> <?php } if($show_more_button == 1){?> <div id="bottomMoreButton"> <a id="more_<?php echo @$next_records?>" class="more_records" href="javascript: void(0)">Older Posts</a> </div> <?php }?> Link to comment https://forums.phpfreaks.com/topic/244873-make-profile-pic-show-next-to-name/ Share on other sites More sharing options...
MasterACE14 Posted August 16, 2011 Share Posted August 16, 2011 you have... <?php echo $link123; inside a while loop. It's going to display it for each iteration of the loop(again and again until there is no more records fetched). Link to comment https://forums.phpfreaks.com/topic/244873-make-profile-pic-show-next-to-name/#findComment-1257919 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.