Re: [PHP-DB] Values in a date field

[bedul]

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 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 date(n, strtotime($subscription_begins));

?
$sql=SELECT id,date FROM SomeTable where date2006-11-31 and 2007-1-1;
mysql($sql);
?

the main problem is... what field u search for? are those a birthday field
or what?
my opinion was, the only reason u search like this is for birthday field.


 http://us3.php.net/manual/en/function.date.php

 -TG

 = = = Original message = = =

 I have a $subscription_begins variable.  It the date type.  -MM-DD

 How may I find out the month value (1 to 12) of this variable?

 Ron


 ___
 Sent by ePrompter, the premier email notification software.
 Free download at http://www.ePrompter.com.

 --
 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-DB] Values in a date field

[Ron Piggott]

I have a $subscription_begins variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron

答复: [PHP-DB] Values in a date field

[Jacob]

$date=Getdate($subsciption_begins);
$month=$date[mon]
-邮件原件-
发件人: Ron Piggott [mailto:[EMAIL PROTECTED] 
发送时间: 2007年3月17日 21:45
收件人: PHP DB
主题: [PHP-DB] Values in a date field


I have a $subscription_begins variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron

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

RE: [PHP-DB] Values in a date field

[Bastien Koert]

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 variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron



_
Don’t waste time standing in line—try shopping online. Visit Sympatico / MSN 
Shopping today! http://shopping.sympatico.msn.ca


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

Re: [PHP-DB] Values in a date field

[tg-php]

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 date(n, strtotime($subscription_begins));

http://us3.php.net/manual/en/function.date.php

-TG

= = = Original message = = =

I have a $subscription_begins variable.  It the date type.  -MM-DD

How may I find out the month value (1 to 12) of this variable?

Ron


___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

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