PHP MySQL and DATE

Posted on 16th Feb 2014 07:03 pm by admin

Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-27. If i have a php interface and want to use a query to select all the rows that is in say october. how would the query look like?? Because i know how to check the whole date, but I want a query that only checks the months... Please help!

Thanks

Your Answer:

Login to answer

Other forums

HeaderSelectedCssClass not working
I have an accordian where I have a drop down list in the first pane and a grid in the second pane.

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i

Spaghetti Code
So.

I've pretty much reached the point where I have so many isset s on one page that I can't

compile php5 with DOM
Hi,

I can't manage to compile php 5.3.0 from source on Windows to include DOM,
in spite of

Problem with HTML form
Hello,

I made a HTML form with some fields and check box.
Everything works fine except whe

Word filter problem
Hello,

im trying to make a filter for words inputted in to my website but i want to store the

Show specific day of the week
I have been racking my brain trying to get this function to work properly and it is doing so for eve

login box shows up again after logging in 2nd login works
Hello,

I am having trouble on my site Lockerz.rack111.com where when you login the login box

Displaying data from database into a 2 dimensional table
Good day!

I'm a beginner in PHP and I'm not expecting a full coding for this qestion. I'm jus