try SUBSTRING http://www.mysql.com/doc/en/String_functions.html Peter -----Original Message----- From: Bruce Levick [mailto:brucel@ispye.com] Sent: 13 February 2003 22:23 To: php-db@lists.php.net Subject: first 10 or so words Howdy, I have a SELECT query displaying the results in repeated rows in a table. I have a COMMENTS column coming out of the database table which will likely contain a paragraph of information. I would like to display only the first 10 or so words and then have a more link that people can click on to display all the info. Is there a simple method for this?? Cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
