Problemer med count(*)

PHP kode 

 include "../connect.php";
 
 $getnummessages = "SELECT COUNT(*) AS messagecount FROM chatmessages";
 $getnummessages2 = mysql_query($getnummessages) or die("blah");
 $getnummessages3 = mysql_result($getnummessages2, 0);
 
 if($getnummessages3 >= 21)
 {
 
    $startrow = $getmessages3 - 20;
 }
 else
 {
   $startrow = 1;
 }
 
 function Smiley($texttoreplace)
 {
     $smilies = array( 
 
     ";)" => "<img src=\"smileys/cool.gif\">",
 
     ";-)" => "<img src=\"smileys/cool.gif\">",
 
     ":-)" => "<img src=\"smileys/smile.gif\">",
 
     ":)" => "<img src=\"smileys/smile.gif\">",
 
     ":(" => "<img src=\"smileys/frown.gif\">",
 
     ":-(" => "<img src=\"smileys/frown.gif\">",
 
     ":D" => "<img src=\"smileys/mdr.gif\">",
 
     ":-D" => "<img src=\"smileys/mdr.gif\">",
 
     "^^" => "<img src=\"smileys/^^.gif\">",
 
     "666*" => "<img src=\"smileys/666.gif\">",
 
     ":'(" => "<img src=\"smileys/cry.gif\">",
 
     "cry*" => "<img src=\"smileys/cry.gif\">",
 
     ":|" => "<img src=\"smileys/erf.gif\">",
 
     ":-|" => "<img src=\"smileys/erf.gif\">",
 
     ":o" => "<img src=\"smileys/eek.gif\">",
 
     ":-o" => "<img src=\"smileys/eek.gif\">",
 
     "fuck" => "$#$%",
 
     "Fuck" => "&$#@"
     );
 
     $texttoreplace = str_replace(array_keys($smilies), array_values($smilies), $texttoreplace);
     return $texttoreplace;
 }
 $aitter = "SELECT * FROM chatmessages";
 $result = mysql_query($aitter);
 $counter = mysql_num_rows($result);
 
 $getmsg = "SELECT name, message FROM chatmessages ORDER BY postime ASC LIMIT $startrow,$counter";
 
 $getmsg2 = mysql_query($getmsg) or die(mysql_error());
 
 while($getmsg3 = mysql_fetch_array($getmsg2))
 
 {
     $message = $getmsg3['message'];
     $message = Smiley($message); //Smiley faces
     $hej_test = $getmsg3['name'];
     $query = "SELECT * FROM users WHERE username='$hej_test'";
     $result = mysql_query($query);
     $admin_test = mysql_fetch_assoc($result);
 ?>    
     <font <?php if($admin_test['id_privil_fk'] == "1")
                 {
                     echo "color='red'";
                 } elseif(!isset($admin_test['id_privil_fk'])) {
                     echo "color='grey'";
                 } else {
                     echo "color='green'";
                 }
             ?>
             ><b><?= $getmsg3['name']; ?>:</b></font> <?= $message; ?><br>
 <?php
 }
 ?>
 
 <script>
 
   setTimeout("window.location.replace('chatlog.php')",2000);
 
 </script>

PHP kode 

 <?php
 function Smiley($texttoreplace) {
     $smilies = array( 
         ";)" => "<img src=\"smileys/cool.gif\">",
         ";-)" => "<img src=\"smileys/cool.gif\">",
         ":-)" => "<img src=\"smileys/smile.gif\">",
         ":)" => "<img src=\"smileys/smile.gif\">",
         ":(" => "<img src=\"smileys/frown.gif\">",
         ":-(" => "<img src=\"smileys/frown.gif\">",
         ":D" => "<img src=\"smileys/mdr.gif\">",
         ":-D" => "<img src=\"smileys/mdr.gif\">",
         "^^" => "<img src=\"smileys/^^.gif\">",
         "666*" => "<img src=\"smileys/666.gif\">",
         ":'(" => "<img src=\"smileys/cry.gif\">",
         "cry*" => "<img src=\"smileys/cry.gif\">",
         ":|" => "<img src=\"smileys/erf.gif\">",
         ":-|" => "<img src=\"smileys/erf.gif\">",
         ":o" => "<img src=\"smileys/eek.gif\">",
         ":-o" => "<img src=\"smileys/eek.gif\">",
         "fuck" => "$#$%",
         "Fuck" => "&$#@"
     );
 
     $texttoreplace = str_replace(array_keys($smilies), array_values($smilies), $texttoreplace);
     return $texttoreplace;
 }
 
 include "../connect.php";
 
 $sql = "SELECT name, message FROM chatmessages ORDER BY postime DESC LIMIT 20";
 $query = mysql_query($sql) or die(mysql_error());
 
 $data = array();
 while($row = mysql_fetch_array($query)) {
     $message = $row['message'];
     $message = Smiley($message); //Smiley faces
     
     $sql = "SELECT * FROM users WHERE username='$row['name']'";
     $query = mysql_query($sql);
     $result = mysql_fetch_assoc($result);
     
     if($result['id_privil_fk'] == "1") {
         $row['__color'] = '#ff0000';
     } elseif(!isset($result['id_privil_fk'])) {
         $row['__color'] = '#cccccc';
     } else {
         $row['__color'] = '#00ff00';
     }
     $data[] = $row;
 }
 $data = array_reverse($data);
 
 foreach($data as $row) {
     echo '<div><span style="color: '.$row['__color'].';font-weight: bold;">'.$row['name'].':</span> '.$message.'</div>';
 }
 ?>
 <script>
   setTimeout("window.location.replace('chatlog.php')",2000);
 </script>

PHP kode 

 $sql = "SELECT name, message FROM chatmessages ORDER BY postime DESC LIMIT 0,20";
  $query = mysql_query($sql) or die(mysql_error());

PHP kode 

 $aitter = "SELECT * FROM chatmessages";
 $result = mysql_query($aitter);
 $counter = mysql_num_rows($result);
 
 if($counter >= 19)
 {
     $startrow = $counter - 19;
 } else {
     $startrow = 0;
 }
 $getmsg = "SELECT name, message FROM chatmessages ORDER BY postime ASC LIMIT $startrow,$counter";
 
 $getmsg2 = mysql_query($getmsg) or die(mysql_error());
 
 while($getmsg3 = mysql_fetch_array($getmsg2))
 {
 ........

Kode 

if($getnummessages3>21)
{
   $startrow = $getmessages3-20;
}

Kode 

if($getnummessages3>21)
{
   $startrow = $getnummessages3-20;
}

Tror han er ude i noget paging bare med en ualmindelig løsning

Hehe.

Det eneste jeg ville gøre er at den kun skal vise de 19 nyeste indlæg i chatten..

Og for mig virker det fint. Der er selvfølgelig en bedre måde at gøre det på men jeg har ikke kunne finde eller regne den ud

Kode 

SELECT * FROM some_table ORDER BY id DESC LIMIT 20