Displaying few words from record in mySQL

From: 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/

« previous php.general (#138674) next »