RE: [PHP-DB] string From: John Coder (jcoder <email protected>)
Date: 10/31/02

Didn't even think of looking for a mysql function to accomplish this.
Thanks.

On Thu, 2002-10-31 at 20:52, Beau Lebens wrote:
> you can do this as a part of your db query
>
> check the string functions available for your rdbms.
>
> mysql would use something like;
>
> SELECT SUBSTRING(monthname(blah), 0, 3) AS monthAbbrev FROM tablename
>
> from memory
>
> HTH
>
> beau
>
> // -----Original Message-----
> // From: John Coder [mailto:jcoder <email protected>]
> // Sent: Friday, 1 November 2002 9:47 AM
> // To: php-db <email protected>
> // Subject: [PHP-DB] string
> //
> //
> // I want to list months found in db by the first three letters as in an
> // abbrevaition of the months i.e.:
> // Jan
> // Feb
> // Mar
> // Apr
> // and so forth
> // I can get the names by monthname(blah) but am stuck on converting
> // strings to first three letters I"ve been trying explode("",$blah) but
> // that doesn't work. I'm at a loss here I can't find the correct string
> // function for this. help would be greatly appreciated.
> //
> // John Coder
> //
> //
> //
> //
> // --
> // 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
> 

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