PHP - Help Me With Adf.ly Clone

Hey guys, i'm creating a facebook clone. Almost there, got the main/basic features all done, however i've got one piece of code which is really bugging me, don't worry about it being messy and horribley coded. I will be improving and optimising it every chance i get once i've got this down.

it's on the main page, i want it to display all recent status' that have been made, i can display them however i think i've bugg'd the SQL somewhere and it's driving my crazy, any help would be greatly appriciated

Thanks

Code: [Select]
  <?php
   $sql = mysql_query("SELECT * FROM statuses ORDER BY id DESC");
    $sql = mysql_query("SELECT * FROM statuses LEFT JOIN users ON statuses.userid = users.id");
while ($row = mysql_fetch_assoc($sql)) {
$status_id = $row['id'];
$status = $row['status'];
$time_posted = $row['time_posted'];
$sql2 = mysql_query("SELECT username,avatar_url FROM users WHERE id=$userid LIMIT 1");
while ($row2=mysql_fetch_array($sql)){
$usernamestatus = $row2['username'];
$avatar_url = $row2['avatar_url'];
echo '<div id="content">';
echo "<img src='/photos/$usernamestatus/$avatar_url' height='50px' width='50px' />";
echo "<a href=\"profile.php?id=$userid\">". $usernamestatus ."</a>";
echo "<br />";
echo $status;
echo " <span class=x><a href=delete_status.php?id=$status_id>x</a></span>";
echo "<br />";
echo time_ago($time_posted);
echo "<br />";
echo "<br />";
echo "</div>";
}
}
}
?>

Deprecated: Function session_register() is deprecated in /home/james/public_html/funshizzle.com/install/session.php on line 0


That is my error, I have no idea, What is it?

I came across the PHP clone method. Does this clone first level fields and methods or does it also do deep copying e.g. copying references to those fields. For example, a field may be an array. Does it make a copy of the actual array or does it refer to the same array position in memory, so if the original changes, then the copy's changes as well?