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 resolution, SUBSTRING_INDEX(description,' ',6) as description FROM rmstable2 WHERE sso LIKE '%{$sso}%'");
The results show up in a table sort of like this:
Description: php here
Resolution: php here
Additional Notes: php here
and so on...