RE: [PHP-DB] Only a section from the database result
| From: | Dwight Altman | Date: | Tue, 18 Jul 2006 17:53:01 +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-42224@lists.php.net to get a copy of this message | ||
substr
Regards,
Dwight
> -----Original Message-----
> From: Benjamin Adams [mailto:badams@ambrosiasw.com]
> Sent: Tuesday, July 18, 2006 12:25 PM
> To: PHP DB
> Subject: [PHP-DB] Only a section from the database result
>
> 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
>
> --