Hi,

to get the first 150 chars of a mysql filed do this:
SELECT LEFT(YourField, '150') FROM YourTable WHERE YourCondition=true;
This does it in MySQL and for PHP follow the mentioned substr-method.

cheers
Johannes

""Jorn van Eck"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
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]

Reply via email to