RE: [PHP-DB] string From: Beau Lebens (B.Lebens <email protected>)
Date: 10/31/02

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