________trim text size or MySQL Query Array______

[Lynux]

Does anyone know right off what function will allow me to trim the number of characters that a query field returns (or any variable/array for that matter)?

For example A MySQL query returns a field with 18 characters.. I am wanting to trim and display only the first 10 characters.

Thanks in advance !

=================================
Imagination is more important than knowledge.
(A.E.)

 

[DumTech]

This function might be what you're looking for:

http://www.php.net/manual/en/function.substr.php

$trimmedfield = substr($fieldtotrim,0,10); Matt
matt@paperlove.org
If I can help, I will.

 

[Broccoli2]

Altertatively, if you don't need the trailing characters at all in your php script, get MySQL to do the work for you:

SELECT LEFT(fieldname,10) AS shortfieldname
FROM yourtable;

-Rob