Trim and Loop Limit Question

[TecTao]

I want to loop through a table of current news articles.  On a page I want to trim the articles down to display only the first say 200 characters.  Also I want to have it loop through and display only the 5 most recent entries.

 

Any help on the query

 

Thanks in advance

m

[revraz]

Post what you have so far.

[TecTao]

Here's the beginning code:

 

<?

 

$results = mysql_query("SELECT * FROM current_news ORDER BY n_date");

 

while ($row = mysql_fetch_array($results))

  {

    extract($row);

 

echo $n_news;

 

$row_count++;

}

 

mysql_close;

?>