On 22-Mar-01 Mike Roberts wrote:
> Probably easy, but everything is easy once you know how to do it.
>
> In my database with PHP and MySQL, I have a description field with
> varchar set to 255. But what I want to do is have the database spit
> that out onto a webpage but only showing, say 100 characters.
>
>
select left(de_fld,100) from da_table;
... also checkout PHP substr().
and now you know how.
Regards,
--
Don Read [EMAIL PROTECTED]
-- If you are going to sin, sin against God, not the bureaucracy.
God will forgive you but the bureaucrats won't.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
