I need to add the "..." at the end of the fields that are getting cut off
===

I want description, resolution and additional_notes to get cut off when it gets longer than 6 words and then have the "..." with a link to "see full case". I only want this to show on the fields that got cut off, not the ones that are less than 6 words because the full field would already be showing. If you guys could please help me figure out how to do this it would make my day! thank you!

I have this query which so far only works to get the field to cut off at 6 words:





$sql = ("SELECT id, sso, case_status, assigned_to, updated, created, SUBSTRING_INDEX(additional_notes,' ',6) as additional_notes, SUBSTRING_INDEX(resolution,' ',6) as description, SUBSTRING_INDEX(resolution,' ',6) as description FROM rmstable2 WHERE sso LIKE '%{$sso}%'");


The results show up in a table sort of like this:

Description: php here <br>
Resolution: php here <br>
Additional Notes: php here <br>
and so on...