[SOLVED] mysql +select only 20 results

[blueman378]

hi guys i have a code which selects data from a mysql database and orders it by gplays,

basically i want this to only select 20 results with the highest gplays,

 

any ideas?

 

<?php
    global $database;
    $q = "SELECT * FROM " . Games . "
          ORDER BY `gplays` ASC
         ";   
    $result = $database->query($q) or die("Error: " . mysql_error());
    /* Error occurred, return given name by default */
    $num_rows = mysql_numrows($result);
    if( $num_rows == 0 ){
      return 'Game Not Found!';
    }
    while( $row = mysql_fetch_assoc($result) ) {
    echo "<tr>
<td class='topgamerow'>
<a href='showgame.php?game=".$row['gName']."'>
".$row['gName']."</a>
</td><td class='topgamerow' align='right'>
".$row['gplays']."
</td></tr>";
    }

?>

[blueman378]

inserting

LIMIT 0, 20

would select only twenty results but would it select thehighest ones? or jut the first entrys in the database, based on th fact that the select orders by gplays

[farkewie]

<?php
   global $database;
   $q = "SELECT * FROM " . Games . "
         ORDER BY `gplays` ASC LIMIT 20
        ";   
   $result = $database->query($q) or die("Error: " . mysql_error());
   /* Error occurred, return given name by default */
   $num_rows = mysql_numrows($result);
   if( $num_rows == 0 ){
     return 'Game Not Found!';
   }
   while( $row = mysql_fetch_assoc($result) ) {
   echo "<tr>
<td class='topgamerow'>
<a href='showgame.php?game=".$row['gName']."'>
".$row['gName']."</a>
</td><td class='topgamerow' align='right'>
".$row['gplays']."
</td></tr>";
   }

?>

[blueman378]

thanks

[farkewie]

inserting

LIMIT 0, 20

would select only twenty results but would it select thehighest ones? or jut the first entrys in the database, based on th fact that the select orders by gplays

 

Beat me to it!1   plus please follow blueman378  and add the "LIMIT 0, 20" not just LIMIT 20,

 

if gplays is a number then you should get the 20 you want