Need help restricting results

[Smad]

Hi all.

This is my snippet of code without my added attemtps :)

I have tried various ways but to no avail. I am trying to only display 2 results based on date, but cant seem to make it display only 2.

Thanks for any help.

$sql = 'SELECT * FROM brokerage ORDER by date';
$result = mysql_query($sql, $conn);
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_array($result))
{
print "<br /><b>".stripslashes($row['model'])."</b>";
}

[justageek]

$sql = 'SELECT * FROM brokerage ORDER by date limit 2';

JAG

[Smad]

thanks... much appreciated