Displaying from database limited to ten

[Anon]

I have another problem. Lets say I want to display news but only have it display 10 or less which would be the most current news. Would I put a for statment in their or what. Here is the code I have to display the news. Thanks in advance for any help given.

$sql= "SELECT * FROM news ORDER BY newsid";
$result =@($sql, $connection) or die("Couldnt excecute query.");
while ($row = mysql_fetch_array($result)) {
$title =$row['title'];
$image =$row['image'];
$news =$row['news'];
$date =$row['date'];
$id =$row['newsid'];
if ($image) {
$image1= "$image";
} else {
$image1= "gen_1x1_transparent.gif";
}

$display_text .="<table border=0 cellpadding=0 cellspacing=0 align=center width='372'>
<tr>
<td class='newstitle'> $title </td>

    </tr>
    <tr> 
      <td><img src='images/gen_1x1_transparent.gif' width='30' height='1'>$news</td>
	  <td width='118'><img src='images/$image1'><br></td>
	  </tr>
	  <tr>
      <td class='date' align=right>$date</td>
    </tr>

  </table >";

}

[Anon]

Hello,

There is a LIMIT command in SQL. Like this:

sql= "SELECT * FROM news ORDER BY newsid LIMIT 10";

This will get the first 10 rows.

Bill

[Anon]

I did not know that Thank you

[Anon]

One more Question? How will I display the ones after ten?
Thanks
Peter

[mithril]

You'll need another query to grab those records. The following query will return all but the first 10 rows.

&nbsp;&nbsp;$sql= "SELECT * FROM news ORDER BY newsid LIMIT 10,-1";

-geoff

[[deleted]]

In short:

LIMIT offset, length

if you want to select records 10 through 30, that's 20 records starting from 10:
LIMIT 10,20

If you are selecting in pages of 10, you can do this:

LIMIT ($page-1)*10, 10

that will automatically select the page for you (starting at page 1)