Displaying few words from record in mySQL
| From: | Rahul.Brenda | Date: | Fri, 07 Mar 2003 18:22:01 +0000 |
| Subject: | Displaying few words from record in mySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-138674@lists.php.net to get a copy of this message | ||
Glory & Supreme Power
What i'm looking to do is.. i want to display only the
first few words of the record in my mySQL database..
For example.. i have a table with a field "title"..
and let's say my last record has the value in title
field as
"This is going to be really cool"
What i want to display is
"this is going..."
Basically this is for News Headlines. I have a page
which displays news but on the first page of the site
i have to give the first few words of the last 4
articles in the news table..
How can i do this? I have seen this in a lot of places
but i dont know how to do this.
Thanks,
Rahul S. Johari
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/