RE: [PHP-DB] string
| From: | Beau Lebens | Date: | Fri, 01 Nov 2002 01:52:08 +0000 |
| Subject: | RE: [PHP-DB] string | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22870@lists.php.net to get a copy of this message | ||
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@insightbb.com]
// Sent: Friday, 1 November 2002 9:47 AM
// To: php-db@lists.php.net
// 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
//