Limit charecters per view

[pinehead18]

I have an sql scrit $sql = "SELECT * FROM articles;";
$result = mysql_query($sql, $con) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {

$art = $row['article'];
$date = $row['date'];
$author = $row['author'];
$subject = $row['subject'];

}


top_of_article();
echo $subject;
echo ' Posted By:';
echo ' ';
echo $author;
echo '</p>';
echo $art;
bottom_of_article();p.. 

I want to limit how many charecters are displayed at one time.. and after the script hits that limit i want it to say readmore with a link to the whole part.

How might i go about that?
Thanks
Anthony

[Mordecai]

Try this:

$numchars = 200;
if (strlen($art) >= $numchars) {
echo(substr($art,0,200)."<br>\n<a href=\"readmore.php\">Read More...</a>");
}
else {
echo($art);
}

[pinehead18]

Were would that go inside the sql script?

[jstarkey]

It's not SQL. Replace your "echo $art" with his code.