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@insightbb.com] > // Sent: Friday, 1 November 2002 9:47 AM > // To: php-db@lists.php.net > // Subject: 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
