I remeber seeing a way to concat something on the end of a substr query. ie I want to add ............. at the end so it would read This is too long to fit in the .......... using substr('$string' ,0,25); Thanks
I'm not sure about your use of quotes... try this example <?PHP $a = 'A quick brown fox jumped over the lazy dog'; $b = substr($a,0,25).'...'; echo $b; ?> PHP:
You mentioned the word query... are you using substr in mysql or php only? You can CONCAT directly in your MySql query, as well.