Chris.. 2 words for you.. "WOW" and "WOW". This works real well.. thanks. I didn't know it was possible through an SQL statement.
Nik & Kevin, thanks a lot .. but this SQL Query works too efficiently and fast. Thanks again.. Rahul S. Johari > Make mysql do the work for you. > > select substring_index(title, ' ', 20), author from > news order by date desc > limit 4 > // this particular string selects everything before > the first 20 spaces of > your title. __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
