current month?

[techker]

hey guys i have a promo table with a filed that inserts the month (list box select)..

 

i need to do a query to select the current month from the month table?

 

i have tryed month()  now()...

[Maq]

Are you trying to extract the month or insert it?

[techker]

extract the promotion of the month

 

in the month field the client inserts the month.

[fenway]

How is this  stored in the db?

[Maq]

extract the promotion of the month

 

in the month field the client inserts the month.

 

If the client inserts the month, then it seems you should already have it.  Maybe I'm confused.

[techker]

it does ya but i need to extract the promotions for every month.that is why i need it to select the promos from current month

[fenway]

Show us the queries you've tried and what they produce in error.

[techker]

well i tryed alot..lolforget but i  figured that i can use the month()

 

SELECT MONTH('2009-09-00');

 

cause they say with 00 -00 it shows the default..doesnt work

 

so i tryed select all from promotions were month =NOW()

 

no success

 

is there a current month() ?

 

in my fled the months are as is:JANUARY,FEB...

 

but i have a date filed to that maybe i can use.it iserts the date of the creation of the promotion?

[techker]

found this to..

 

SELECT * FROM table WHERE YEAR(date) = YEAR(CURDATE()) AND MONTH(date) = MONTH(CURDATE())

[techker]

ok so i got it going.

 

created a variable :$curr_month = date("m");

 

then select * from pormotions were month = $curr_month ;

 

i need to change the way the months were iserted.

 

now they insert 01(jan) 02(feb)...

[fenway]

Again, when you don't store dates properly, date operations become painful.