echo "<p>" . substr($row['pagetext'], 0, 50) . "</p>"; Regards, Dwight > -----Original Message----- > From: Benjamin Adams [mailto:badams@xxxxxxxxxxxxxx] > Sent: Tuesday, July 18, 2006 12:25 PM > To: PHP DB > Subject: 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 > > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
