Only a section from the database result

[Benjamin Adams <badams@xxxxxxxxxxxxxx>]

I have articles in a MySQL database and I want creating a fast brows  
where people can read read the beginning of the articles and select  
the ones they want to read.

How do I only display the first say 50 chars of a 5000 char article?

$count = 1;
while(($row = mysql_fetch_array($News)) or ($count < 15)){
    if(isset($row['threadid'])){
    echo "<b><a href='./showpost.php?t=" . $row['threadid'] . "'>" .  
$row['title']. "</a></b><br \>";
    echo "&nbsp;&nbsp;&nbsp;" . $row['dateline'] . " -- by: " . $row 
['postusername'] . "<br \>";
    echo "&nbsp;&nbsp;&nbsp;Views: " . $row['views'] . " - Comments:  
" . $row['replycount'] . "<br \><br \>";
    echo "<p>" . $row['pagetext'] . "</p>"; //This is the variable I  
only want the fist 50 chars
    }
    $count++;
}

Thanks

--Ben

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php