Just run this query avoiding all this php code SELECT SUBSTRING( MyFieldName, 0, 30 ) FROM MyTable
Substring( fieldname, starting position, length ) "Sebastian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Good morning all. > > I have a mysql query that fetches some text. I am limiting the results to > two (2). > > Then i am limiting the text to 30 characters and truncating it with some > "...." Like this: > > if(strlen($title) >= 30) { > $title = substr(trim($title),0,30); > $title = $title.'..'; > } > > But when a $title contains a ! (exclamation point) it only shows one result. > Why is an ! interfering? > > Any suggestions? > > warm regards, > Sebastian - [BBR] Gaming Clan > http://www.broadbandreports.com > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
