I'm trying this code below:

//fetch the user from data base
$sql = "SELECT
user_id,
user_name,
user_rank,
user_motto
FROM
users
WHERE
user_id = " . mysql_real_escape_string($_GET['id']);

$users_result = mysql_query($sql);

if(!$users_result)
{
echo '<tr><td>The user could not be displayed, please try again later.</tr></td></table>';
}

else
{

while($users_row = mysql_fetch_assoc($users_result))
{
echo $users_row;

echo '<tr class="user">
<td class="user-post">' .'<span style="font-size:20px;color:red;align:center">' . $users_result['user_rank'] . '</span>' . '<br>' . $users_result['user_name'] .'<br/>' . '<br/>' . 'Joined: <br>' . $users_result['post_date'] . '</td>
<td class="user-motto" width=85%>' . '<br><br>Motto: ' . '<br><br><br>' . $users_result['user_motto'] . '</td>
</tr>';

}
}

//finish the table
echo '</table>';
It gives an array for $users_row. But all the entrys seem null.
I have all the tables made, I've had no problems with it until this point.
Okay your fix, made the first two display properly.
But the rest don't show up what so ever.