Hello all,
Sorry if this is basic, but I'm pretty lost on how to achieve the following: I have a MySQL database containing a call ticket tracking system. One of the fields in the table is a text box where a tech can enter a sentence about the problem our user was having.
Unfortunately, some of our techs have taken to putting all their notes in this one field, which has made for much longer than anticipated entries. What I need to do now is to be able to either limit the query so it only returns the first x characters of the field, or use PHP to chop off any remainder of the string after x characters if I can't limit via select.
For example, Say I only wanted 8 characters to be displayed. But there's 24 characters in the field, I want to trim the string to ditch the last 16 characters. My hunch is that it's an eregi_replace command, but regexps have never been my strong suit. 🙂
Thanks!
