byteMyCode: Snippet Revisions http://www.bytemycode.com Revisions for this snippet. Wed, 03 Dec 2008 20:55:20 +0000 1998-2008 en-us http://www.bytemycode.com http://www.bytemycode.com/img/rss_title.gif byteMyCode MySQL Lead-In Sentence fragment... 1 http://www.bytemycode.com/snippets/snippet/413/1/ http://www.bytemycode.com/snippets/snippet/413/comments/ Thu, 05 Oct 2006 11:49:42 +0000 Idlemind mysql, PHP http://www.bytemycode.com/snippets/snippet/413/ "Today in the news, MySQL previews..."

As a "preview" of text, this MySQL select will return the first few words out of a text field in a database. It returns entire words (doesn't cut them off in the middle) and follows the last word with an elipse "..."

In the PHP, assign $CharactersToDisplay to a number - the approximate number of characters desired (or you can hard-code it if you want).

For the example, I also use $TheID as the row identity for the record to display.

]]>