PHP - Users Avatar

I need some help with my commenting system. at the moment the code is like this:

<div id="pagepannel">
                <div id="ptop_small">Comments</div>
                <div id="pbottom_small">
          <p>
            <?php 
//
if ($allow_comments == "no") {
?>
          </p>
          <p>No Posting comments here!!!</p>
          <p>&nbsp;</p>
          <p>&nbsp;</p>
          <p>
            <?php } else ?>
          </p>
          <p>
            <?php 
  $sql = "SELECT comment_id, blog_id, posted_by, comment, stamp, email, type FROM jscrgaming_newscomments WHERE blog_id='$blog_id'  ORDER BY comment_id DESC";
$result = mysql_query($sql) or die('Error : ' . mysql_error()); 
      while(list($comment_id, $blog_id_co, $username, $comment, $stamp, $email, $type) = mysql_fetch_array($result, MYSQL_NUM))
{ 
if ($type == 'user'){
?>
          </p>
          <table width="95%" border="0" cellpadding="0" cellspacing="0" class="full_border">
            <tr>
              <td width="75" id="avatar"></td>
              <td><span class="capitalize"><a href="userinfo.php?user=<? echo $username ?>"><strong><? echo $username ?></strong></a></span><strong> posted</strong>: <? echo stripslashes($comment) ?></td>
            </tr>
            <tr>
              <td colspan="2" bgcolor="#CAE4FF" class="date"><? echo $stamp ?>&nbsp;</td>
            </tr>
          </table>
          <p>&nbsp;</p>
          <p>
            <? } 
else{
?>
          </p>
          <table width="95%" border="0" cellpadding="0" cellspacing="0" class="full_border">
            <tr>
              <td><strong> <? echo $username ?>posted</strong>: <? echo stripslashes($comment) ?></td>
            </tr>
            <tr>
              <td bgcolor="#CAE4FF" class="smalltext"><? echo $stamp ?>:: User Was Guest</td>
            </tr>
          </table>
          <p>&nbsp;</p>
          <p>
            <? } }?>
          </p>
          <p>
            <?php 
//
if ($allow_comments == "restricted") {

/**
 * User has already logged in, so display relavent links, including
 * a link to the admin center if the user is an administrator.
 */
if($session->logged_in){?>
          </p>
          <form id="form3" name="form3" method="post" action="user/admin/blog/comment_system/user.php">
            <p>&nbsp;</p>
            <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
              <tr>
                <td colspan="2">You are commenting as <?php echo $session->username;?></td>
              </tr>
              <tr>
                <td width="75">Message</td>
                <td><textarea name="co_comment" cols="30" id="textfield10"></textarea></td>
              </tr>
              <tr>
                <td width="75"><span class="header">
                  <input name="co_username" type="hidden" id="co_username" value="<?php echo $session->username;?>" />
                  <input name="co_blog_id" type="hidden" id="co_blog_id" value="<?php echo $blog_id ?>" />
                </span></td>
                <td><label>
                  <input type="submit" class="blog_button" value=" Post " />
                </label></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td class="smalltext">only 200 charaters can be used</td>
              </tr>
            </table>
          </form>
          <p>&nbsp; </p>
          <p>
            <? } else {?>
          </p>
          <p>&nbsp;</p>
          <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
            <tr>
              <td width="75"><span class="capitalize">Name</span></td>
              <td><label>
                <input name="textfield5" type="text" disabled="disabled" id="textfield5" size="35" />
              </label></td>
            </tr>
            <tr>
              <td width="75">Email</td>
              <td><input name="textfield5" type="text" disabled="disabled" id="textfield6" size="35" /></td>
            </tr>
            <tr>
              <td width="75">Message</td>
              <td><textarea name="textfield5" cols="30" disabled="disabled" id="textfield7">You need to be logged in to comment.</textarea></td>
            </tr>
            <tr>
              <td width="75">&nbsp;</td>
              <td><label>
                <input type="button" class="blog_button" value=" Post " />
              </label></td>
            </tr>
          </table>
          <p>&nbsp;</p>
          <p>
            <?php } } else { 
  if($session->logged_in){?>
          </p>
          <form id="form2" name="form2" method="post" action="user/admin/blog/comment_system/user.php">
            <p>&nbsp;</p>
            <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
              <tr>
                <td colspan="2">You are commenting as <?php echo $session->username;?></td>
              </tr>
              <tr>
                <td width="75">Message</td>
                <td><textarea name="co_comment" cols="30" id="textfield8"></textarea></td>
              </tr>
              <tr>
                <td width="75"><input name="co_username" type="hidden" id="co_username" value="<?php echo $session->username;?>" />
                  <input name="co_blog_id" type="hidden" id="co_blog_id" value="<?php echo $blog_id ?>" /></td>
                <td><label>
                  <input type="submit" class="blog_button" value=" Post " />
                </label></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td><span class="smalltext">only 200 charaters can be used</span></td>
              </tr>
            </table>
          </form>
          <p>&nbsp; </p>
          <p>
            <? } else { ?>
          </p>
          <form id="form1" name="form1" method="post" action="user/admin/blog/comment_system/guest.php">
            <p>&nbsp; </p>
            <table width="95%" border="0" align="center" cellspacing="2" class="full_border">
              <tr>
                <td width="75"><span class="capitalize">Name</span></td>
                <td><label>
                  <input name="co_username" type="text" id="co_username" size="35" />
                </label></td>
              </tr>
              <tr>
                <td width="75">Email</td>
                <td><input name="guest_email" type="text" id="guest_email" size="35" /></td>
              </tr>
              <tr>
                <td width="75">Message</td>
                <td><textarea name="co_comment" cols="30" id="co_comment"></textarea></td>
              </tr>
              <tr>
                <td width="75">Spam</td>
                <td>&nbsp;</td>
              </tr>
              <tr>
                <td colspan="2" align="center"><? require_once('user/captcha/recaptchalib.php');
$publickey = "6Ld_W7sSAAAAAPNTLWrUJLEClFpSSPu1d1Ry5zNR"; // you got this from the signup page
echo recaptcha_get_html($publickey); ?></td>
              </tr>
              <tr>
                <td colspan="2" align="right"><span class="smalltext">only 200 charaters can be used</span>
                  <input name="co_blog_id" type="hidden" id="co_blog_id" value="<?php echo $blog_id ?>" />
                  <input type="submit" class="blog_button" value=" Post " /></td>
              </tr>
            </table>
          </form>
          <p>&nbsp; </p>
          <p>
            <? } } ?>
          </p>
<p>&nbsp;</p>
                  <div></div>
                </div>
              </div>


I, know its a bit messy but lets me see it and design it in Dreamweaver

Any way, for the comment system for users, I want it to show their avatar as well, which is stored in the users table. How would one do this.

I did think of it submitting the avatar along with the post but then it wouldnt update if the user would to change their avatars :\

Any helps???

Hi ppl

got code problem cant get it show users avatar & blank avatar at same time not that good at
php ppl.

avatar box page

Code: [Select]
<style type="text/css">
#name_area{height:20px; padding:3px;};
</style>
<script language="javascript">
<!--
function member_change(id){
<?php
$allgames = mysql_query("SELECT * FROM games") or die (mysql_error());
$allgames_total = @mysql_num_rows($allgames);
if($allgames_total!=0)
{
$i=0;
while($i<$allgames_total)
{
?>
document.getElementById('<?php echo mysql_result($allgames, $i, 'game_id'); ?>').style.display = "none";
<?php
$i++;
}
}
?>
document.getElementById(id).style.display = "block";
}
function show_name(name){

document.getElementById('name_area').innerHTML = name;
}
function hide_name(){
document.getElementById('name_area').innerHTML = '';
}
//-->
</script>

<div style="text-align:left;">
Choose Squad: <select name="D1" onchange="member_change(this.options[this.selectedIndex].value)" class="standardforms">
<?php
$allgames = mysql_query("SELECT * FROM games") or die (mysql_error());
$allgames_total = @mysql_num_rows($allgames);

if($allgames_total!=0)
{
$i=0;
while($i<$allgames_total)
{
$game = mysql_result($allgames, $i, 'game_title');
$members_total2 = mysql_num_rows(mysql_query("SELECT * FROM members WHERE game = '$game'"));

if($members_total2!=0)
{
?>
<option value="<?php echo mysql_result($allgames, $i, 'game_id'); ?>"><?php echo mysql_result($allgames, $i, 'game_title'); ?></option>
<?php
}
$i++;
}
}
?>
</select><br /><br />
</div>
<?php
$allgames = mysql_query("SELECT * FROM games") or die (mysql_error());
$allgames_total = @mysql_num_rows($allgames);
if($allgames_total!=0)
{
$i=0;
while($i<$allgames_total)
{
$game = mysql_result($allgames, $i, 'game_title');
$members = mysql_query("SELECT * FROM members WHERE game = '$game'");
$members_total = @mysql_num_rows($members);

if($allgames_total!=0)
{
?>
<div id="<?php echo mysql_result($allgames, $i, 'game_id'); ?>" style="display: block; text-align:left;">
<?php

if($members_total!=0)
{
$d=0;
while($d<$members_total)
{

?>
<a href="index.php?page=members&amp;id=<?php echo mysql_result($members, $d, 'id'); ?>"><img onmouseover="show_name('<?php echo mysql_result($members, $d, 'username'); ?>')" onmouseout="hide_name()" src="user/<?php

  echo mysql_result($members, $d, 'avatar_link');

$filename = 'avatar_link';

if (file_exists($filename)) {
     echo "avatar_link";
} else {
     echo "avatars/blank.jpg";
}


?>" width="50" height="50" alt="<?php echo mysql_result($members, $d, 'username'); ?>" title="<?php echo mysql_result($members, $d, 'username'); ?>"/></a>
<?php
$d++;
}
}
}
echo "</div>";
$i++;
}
}
?>
<div id="name_area"></div>

Hi everyone,

  I need some help. I have made a comment system, where users have to be logged in to post their comments. I am stuck at displaying an avatar for each user. What I am trying to do is, there is a table for users login details and their avatar than there is a table for comments.
I would like to do is take the users avatar from the login table and post it in the comments table, when the user comments, so I can echo different avatars, depending on who commented, if there is a different more simpler way I would like to know it. Thanks in advance.

Hello   I am trying to work out how many regular users I have to my site and how long those users tend to be users..   So, I have a table that logs every time a user visits my site and logs in, it stores the date / time as a unix timestamp and it logs their user id.   I started by getting the id's of any user who logs in more than 5 times in a specified period, but now I want to extend that...  

 
SELECT userID as user, count(userID) as logins FROM login_history where timestamp > UNIX_TIMESTAMP('2014-06-01 00:00:00') and timestamp < UNIX_TIMESTAMP('2014-07-01 00:00:00') group by user having logins > 5;
 

Hi i have a chat written in php and as3
at the moment the chat window shows username and message but i want to add a avatar before the username.
here is the code i have.


$sql = mysql_query("SELECT * FROM chat75 ORDER BY date_time ASC");
    while($row = mysql_fetch_array($sql)) {
       $id = $row["id"];
       $user_name = $row["user_name"];
       $chat_body = $row["chat_body"];
      $num = $row["avatar"];
       $date_time = $row["date_time"];
       $chat_body = stripslashes($chat_body);
        $chat_body = eregi_replace("&#39;", "'", $chat_body);
      $string =array();
$files = glob("../images/avs/*.*");
for ($i=1; $i<count($files); $i++)
{
   $num = $files[$i];
   
   }
        $body .= '<b><font color="#006699">' . $num . ': ' . $user_name . ':
       
       <font color="#000000"> ' . $chat_body . '</font>
        <br />';
   
    }

this is what i get in the chat window

../images/avs/avatar9.png: demo123: testing message

i have tried everything to get the avatar to appear in the chat window but keep getting the above,i have tried to put echo in front but then just get a blank chat window.
please help
thanks