Limited results MySQL query - Newbie

Cpt_veerhoek

Hello,

I want to add a box to the main page of my site, so everybody can see what the latest additions are. I already have a good script that lists all entries. My problem is that I don't know how to limit the entries shown, to let's say 10 results.
Can anybody tell me how to make a good script or how to modify my current script so it will show only the latest 10 results?

Listing script:
<?php
require "ezine_db.inc.php";
$ezine_db = ezine_connecte_db();

$str_requete = "SELECT id,stof,auteur,grootte,vak FROM artikel WHERE affichage='$affichage' ORDER BY date DESC";

$result_articles = mysql_query ($str_requete,$ezine_db) or ezine_mysql_die();

print ('<center><table border="1" cellspacing="0">');
print("
<tr>
<td><center>Vak</td>
<td><center>Stof</td>
<td><center>Auteur</td>
<td><center>Grootte</td>
<td><center>Download Link</td>
</tr>
");
while ($articleDb =mysql_fetch_object($result_articles))
{
print("
<tr>
<td><center>$articleDb->vak</td>
<td><center>$articleDb->stof</td>
<td><center>$articleDb->auteur</td>
<td><center>$articleDb->grootte</td>
<td><center><a href='download.php?id=$articleDb->id'>Download nu!</a></td>
</tr>
");
}

print ('</table></center>');

?>

Thanx in advance

barand

Use a LIMIT clause in your select statement

$str_requete = "SELECT id,stof,auteur,grootte,vak FROM artikel WHERE affichage='$affichage' ORDER BY date DESC LIMIT 10";

hth

Cpt_veerhoek

Everybody thanks for the help, I solved my problem with some help and my own keen sence 😃

I've modified it like this:
$str_requete = "SELECT id,stof,auteur,grootte,vak FROM artikel ORDER BY id DESC LIMIT 10";