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

2007-03-19 Thread bedul 
sry.. just check the script.. if able.. plz info me
- Original Message -
From: <[EMAIL PROTECTED]>
To: 
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));

2006-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

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

2007-03-17 Thread 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

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

2007-03-17 Thread 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 
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

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

2007-03-17 Thread 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

[PHP-DB] Values in a date field

2007-03-17 Thread 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