How only show first n characters of field when fields are long

[SJurick]

I used to have a document on how to do this but lost it.

How do I specify for a field to display the first so many characters in a given field when the field is too long to display in a table?

[bregent]

You would use a string function, probably something like Left() but it depends on the language you are using (which you did include in your post).

[SJurick]

Sorry, I'm using PHP, and MySQL.

[bregent]

sjurick wrote:

Sorry, I'm using PHP, and MySQL.

It depends if you want to either truncate the results from the select statement in the script,  or limit what is being returned by the select. You can use the php substr function

http://www.php.net/manual/en/book.strings.php

or the SQL Left() functions

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_left