Re: [PHP-DB] Cropped Text

[Jeffrey_N_Dyke]

if you're using mysql you can use LEFT(column_name, 10) this will return
the first 10 chars of whatever is in column_name.  you could also use
SUBSTRING(col, position, length)...  i'm sure most DB's support variations
of the above.

hth
jeff


                                                                                       
                             
                    "Dallas                                                            
                             
                    Freeman"             To:     <[EMAIL PROTECTED]>                   
                          
                    <[EMAIL PROTECTED]       cc:                                       
                                 
                    pond.com>            Subject:     [PHP-DB] Cropped Text            
                             
                                                                                       
                             
                    03/12/2003                                                         
                             
                    04:21 PM                                                           
                             
                                                                                       
                             
                                                                                       
                             




I dunno what it is called so that is why I am asking, so that I can
search the web about it.
What do you call the method of cropping text back, so that there are a
limited number of characters shown, the rest is cut off.

Thanking You,
Dallas Freeman





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php