How do I limit the number of character in the mysql query, but add a ... if the text is longer than say 20 characters. If it is shorter than 20 character then the ... at the end would not show.
This is what I have so far, it limit the number of character but I do not know how to add the ... at the end.
SELECT LEFT(Help.Name, 20) FROM Help WHERE Help.HelpID = 1
If this is not possible in the mysql query would it be possible in the php echo statement.
e.g the result I am looking if the result of the Help.Name was
to be or not to be that is the question
then the result I am looking for it
to be or not to be t...
but if the query result was less than 20 character a ... would not be added to the end.
Many thanks for your help