show X amount of results

[knowj]

how would i make a simple sql script only get for instance 10 rows of results out of the detabase?

my code is below but i would rather use sql then php to make it only get 10 results


<?
$query = "SELECT * FROM `kj_blog` ORDER BY id DESC";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
echo '<p style="color:#F17416; font-size:0.6em;">'.$row['blog_date']."</p>";
if (!(empty($row['blog_img'])))
{echo '<img class="float-right" alt="'.$row['blog_title'].'" src="images2/'.$row['blog_img'].'">';}
echo "<h1>".$row['blog_title']."</h1>";
echo "<p>".$row['blog_text']."\r\n</p><br>";
echo "<hr>";
}
?>

[candelbc]

Try using LIMIT...


$query = "SELECT * FROM `kj_blog` ORDER BY id DESC LIMIT 10";