Taking first 10 results from database?

[zrweber]

I'm having some difficulty. I've tried a few things with no luck.  :'( Is there a way where I can take only the first 10 results of $row['username']?

 

$query = mysql_query("SELECT * FROM users ORDER BY dirStamp DESC") or die("Sorry there was an error.");
$numrows = mysql_num_rows($query);
while ($row = mysql_fetch_assoc($query)) {
echo $row['username'];
echo "</br>";
}

 

Thanks in advance!

[Maq]

Use LIMIT:

 

SELECT * FROM users ORDER BY dirStamp DESC LIMIT 10

[zrweber]

That's simple! Thank you, that's exactly what I needed.

 

How would I do it if I were to want results 5-10 instead of 1-10?

 

EDIT - Nevermind, I figured it out.

 

Thanks again

[Maq]

Good.  Yeah LIMIT can take 2 params.  I think the first is where you want to start, and the second is how many you want from there.  So results 5-10 would be:

 

LIMIT 5,5

 

(I think)