fetch the records of a particular month

[mrjameer]

hi

 

 

i have a mysql table.it has 2 fields

 

1.register_number 2.registered_date

 

values

333333----2007/08/21

245678----2007/06/30

123123----2007/09/20

123222----2007/09/21

125553----2007/09/22

 

i have select box on a page and it's option values from january-december.

when i select the month from select box and press submit button,it should fetch those records that are registered in that particular month.

 

i just need the sql query logic to fetch the records of that particular month.

any of your help will be surely appreciated

 

thanks

mrjameer

[BlueSkyIS]

use the MySQL mont() function:

 

SELECT * FROM your_table WHERE month(registered_date) = '9';

 

[Dragen]

Change the values to two digit numbers corresponding to the months in the database.

Then have your sql something like:

SELECT * FROM `tablename` WHERE `registered_date` LIKE '%/" . $month_variable . "/%'

ehere $month_variable is the value of the checkbox

[BlueSkyIS]

doh, never mind.

[mrjameer]

hi BlueSkyIS

 

 

your logic worked.it is displaying the results what i want.thanks

 

but when i use like operator it does not display anything.

 

any how thanks for all replys

 

 

thanks

mrjameer