RE: [PHP-DB] Only a section from the database result
| From: | Bastien Koert | Date: | Sat, 22 Jul 2006 02:26:09 +0000 |
| Subject: | RE: [PHP-DB] Only a section from the database result | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42239@lists.php.net to get a copy of this message | ||
http://ca3.php.net/manual/en/function.substr.php is the function you want
bastien
From: Benjamin Adams <badams@ambrosiasw.com>
To: PHP DB <php-db@lists.php.net>
Subject: [PHP-DB] Only a section from the database result
Date: Tue, 18 Jul 2006 13:24:51 -0400
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 " " . $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++;
}
Thanks
--Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php