Lets say there is a field setup in the database with the text attribute set to it which allows large articles to be submitted. Is there a way with the select statement to create a preview.
ex: Instead of going directly into the article and having the full thing printed. Can I just select the first x number of lines in the field?
thanks
Depending on your database, you may be able to use SELECT LEFT(text_col, 5) FROM articles WHERE uid=1234;
This might not work for BLOB/TEXT fields. Otherwise, just do a substr( $text_col, 0, 100 ); to get however many characters you need.
--Robert
