Re: first 10 or so words
| From: | Ignatius Reilly | Date: | Fri, 14 Feb 2003 08:51:26 +0000 |
| Subject: | Re: first 10 or so words | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25626@lists.php.net to get a copy of this message | ||
Or rather
SUBSTRING_INDEX(str,delim,count)
Because you want to use a custom delimiter (space, comma)
Ignatius
____________________________________________
----- Original Message -----
From: "Peter Lovatt" <pjln1@sunmaia.net>
To: "Bruce Levick" <brucel@ispye.com>; <php-db@lists.php.net>
Sent: Thursday, February 13, 2003 11:40 PM
Subject: RE: [PHP-DB] first 10 or so words
> 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
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>