PHP only showing 1 record

[PhillNeedsHelp]

Hey I have made this forum system that displays the users details (username, avatar etc) which is stored in the users table. I have then displayed that info using <?php include('user-info.php'); ?> it displays it but only displays 1 record when there are loads of records... any ideas? Thanks

[wmguk]

we would really need to see all the code that you are using to see why?

 

post the code for us,

[PhillNeedsHelp]

<?php
  
$dbh=mysql_connect ("localhost", "usersl", "pass") or die ('I cannot connect to the database because: ' . mysql_error());
        mysql_select_db ("phil_forum"); 


   $query = "SELECT username, forum  FROM forum WHERE question=$id";
    $result = mysql_query ($query) or trigger_error("Query: $query\n<br />Mysql error: " . mysql_error());

    while($row = mysql_fetch_array($result)) {
     $un = $row['user_name'];

     include('user-info.php');
    
}
?>

That's the forum reply script.. Heres the user-info

 

<?php
$dbh=mysql_connect ("localhost", "user", "pass") or die ('I cannot connect to the database because: ' . mysql_error());
     mysql_select_db ("phil_useraccounts");

   $query = "SELECT user_name, user_id, motto, badge, user_group FROM users WHERE user_name='$un'";
   $result = mysql_query ($query) or trigger_error("Query: $query\n<br />Mysql error: " . mysql_error());

    while($row = mysql_fetch_array($result)) {

   $user = $row['user'];

  echo '<img src="http://www.mysite.com?user=' .$user. '&action=&direction=2&head_direction=2&size=1&img_format=gif"><img 


}
?>

[wmguk]

   $query = "SELECT user_name, user_id, motto, badge, user_group FROM users WHERE user_name='$un'";
[code]
[/quote]

The WHERE says user_name='$un' so im assuming that it will only display the info for the one user, with the one username?

or am i on the wrong lines here?

[/code]

[PhillNeedsHelp]

Thanks.. So any idea how to make it not select the one user? 

[wmguk]

if you just remove the WHERE string, then it will display every user in the database.

[PhillNeedsHelp]

Hey then it shows every user in the users table and not the table for the forum....

[shikeh]

replace the "Where": instead of user, use forum

select....form forum where forum=$selected_forum

 

All the Best

 

Shikeh