[SOLVED] SELECT TOP 3 problem

[Sorrow]

Hi everyone. I need to display only the top 3 items of the query when i do this

<?php

include 'opendb.php';

$query  = "SELECT * FROM reviews Order by m_index DESC ";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo "<a href='/moviereview.php?index={$row['m_index']}'>{$row['m_Title']}</a><br>";

}
mysql_close($con);

?>

 

its ok it displays every entry but I only need the top 3 and I tried

SELECT TOP 3 * FROM reviews Order by m_index DESC
and 
SELECT TOP 3 FROM reviews Order by m_index DESC

 

Any idea what am I doing wrong???

[peranha]

You may want

 

SELECT * FROM reviews Order by m_index DESC LIMIT 0,3

[Sorrow]

thank you very much its working