substr

Regards,
Dwight

> -----Original Message-----
> From: Benjamin Adams [mailto:[EMAIL PROTECTED]
> 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 "&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

Reply via email to