[Kevitt]

I've adjusted your code to spit out the first 100 chars. Look at the line where $story_text is located. Notice $story_text has now become ".substr($story_text,0,100)."

Hope that helps

PHP Code:

<?

$sqlhostname = "localhost";
$login = "******";
$password = "******";
$base = "******";

$db_connect = mysql_connect($sqlhostname,$login,$password);
$base_selection = mysql_select_db($base,$db_connect);

$query = "SELECT * FROM gaming_news ORDER BY id  ASC  LIMIT 0,1";
$req = mysql_query($query);

if (!$req)
{ echo "<B>Error ".mysql_errno()." :</B> ".mysql_error()."";
exit; }
$res = mysql_num_rows($req);

if ($res == 0)
   { echo "<center><b>Sorry there is no result.</b></center>";}
else 
   { while($row = mysql_fetch_array($req))
            {
               extract($row);

                      echo"<img src=\"images/newslatest.gif\" align=\"left\"><b>$headline</b> posted by: <b>$author</b> - ".substr($story_text,0,100)."... <br>[<b>read full story</b>]

";
    }
mysql_free_result($req);
}

?>