PHP/MySQL Limit The Length of the Result
Im pretty new to using MySQL within PHP and have come across a problem. I wondered if it is possible to limit the number of characters or words displayed from a result.
What I am trying to do is have a description which only displays the first say 50 words, the user can then click onto the item to view the full description!
I am just not sure of what SQL code I need to use!
I have tried searching the net, but the only results I get are to do with limiting the number of results returned, not limiting the length of the results themselves.
Any help would be greatly appreciated!