Quero Listar Apenas Os 10 Primeiros Regs

[otavio_araujo]

<?php

include ("includes/config.php");

$y = mysql_query("SELECT * FROM noticias ORDER BY data DESC");

$reg = mysql_num_rows($y);

if ($reg == 0) { echo '<font class="menu"> Não Há Notícias Cadastradas no Momento! </font>';

} else {

echo "<table width='350' border='0'>

<tr>

<td width='' bgcolor='#EFEFEF'><div align='center' class='menu'>Data</div></td>

<td width='' bgcolor='#EFEFEF'><div align='center' class='menu'>Manchete</div></td>

</tr>";

$cor = "#EFEFEF";

$ct = 0;

if ($reg > 10) {

$stop = 10;

}else{

$stop = $reg;

}

while(($x = mysql_fetch_array($y)) or ($ct != $stop)){

if ($cor == "#EFEFEF") {

$cor = "#FFFFFF";

}else{

$cor = "#EFEFEF";

}

$data = explode('-',$x['data']);

echo'

<tr>

<td width=80" bgcolor='.$cor.'><div align="center" class="t_normal"><strong>'.$data[2].'/'.$data[1].'/'.$data[0].'</strong></div></td>

<td width="429" bgcolor='.$cor.' class="t_normal"><a href="noticias/index.php?act=mostrar&id='.$x['id].'" class="t_normal">'.$x['titulo'].'</a></td>

</tr>';

$ct = $ct + 1;

}

echo "</table>";

}

?>

[rzilnet]

$y = mysql_query("SELECT * FROM noticias ORDER BY data DESC LIMIT 0,10");

Espero que resolva!

[otavio_araujo]

Opah resolveu sim!

Obrigado velhinhooooO!!!