[Ember]

Here's the query I have at the moment:

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> - $story_text... <br>[<b>read full story</b>]

";
    }
mysql_free_result($req);
}

?>

I'll be wanting to limit $story_text

Hope that helps you to help me!