sry.. just check the script.. if able.. plz info me
- Original Message -
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Cc: [EMAIL PROTECTED]
Sent: Sunday, March 18, 2007 8:38 AM
Subject: Re: [PHP-DB] Values in a date field
Assuming you're using MySQL, try MONTH(). As in:
SELECT
select date_format(datefield,'%M') as theDate from table [where clause]
Bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Values in a date field
Date: Sat, 17 Mar 2007 09:44:43 -0400
I have a $subscription_begins
Assuming you're using MySQL, try MONTH(). As in:
SELECT MONTH(SomeDateField) FROM SomeTable
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
If this isn't a database question, but a general PHP question, try this:
// For numeric month without leading zero, use n
echo