I have it working with left, Thanks everyone.
On Jul 18, 2006, at 1:57 PM, dpgirago@xxxxxxxxxxxxxx wrote:
I have articles in a MySQL database and I want creating a fast brows
where people can 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 " " . $row['dateline'] . " -- by: " . $row
['postusername'] . "<br \>";
echo " 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++;
}
One possible solution is to select from the database only the first 50
characters for display in the initial page: "SELECT left(FieldName,
50)
FROM tablename";
Once a user has chosen the articles they would like to read, run
another
query and select the entire content field.
David
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
