RE: [PHP-DB] first 10 or so words
| From: | Peter Lovatt | Date: | Thu, 13 Feb 2003 22:40:54 +0000 |
| Subject: | RE: [PHP-DB] first 10 or so words | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25622@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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