You can use MySql's LEFT() or even substring()
example:
SELECT substring(address,1, 20) as _addr FROM tablename
and you will have to look for field "_addr" in mysql results.
-elias
http://www.kameelah.org/eassoft
""Jorn van Eck"" <[EMAIL PROTECTED]> wrote in message
9bkpd8$r77$[EMAIL PROTECTED]">news:9bkpd8$r77$[EMAIL PROTECTED]...
> Hi there,
>
> Does someone know how to display for example150 characters from a $ set by
> MySQL?
> --
> Jorn van Eck
> Student Information Engineering
> Almere
> Tel: +31 614430902
> E-mail: [EMAIL PROTECTED]
> Website: http://www.iie.nl/~eck13
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
