List the data by month

[jeeva]

hi frnds,

 

i have done one form where the data will be listed from the database.Now the user asking me to change the data sholud be list by current month. But i was storing the data like 12-4-2007 here can i list by month?

 

but i know we can do by changing the database but i dont want to change the database its very difficult to change the user database.

 

Any one can help me?

 

[rcorlew]

You should try this if your month is the second number in your in your date format:

 

<?php
$date = date("j-n-Y")

$sql = "Select * FROM table WHERE formdate LIKE '%$date%'"
?>

 

 

 

 

[jeeva]

No it does not seems work

[prabhuksmani]

Hi,

      Use this SQL Query....

 

SELECT *

FROM table

WHERE MONTH( `formdate` ) = MONTH( CURDATE( ) ) ;

 

Thanks

Prabhu