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

Keeping data in form
How can I keep whatever I write in the form?

Is it possible to view php source code??
Hi All

I was just wondering if it's possible to view a websites php source code?
I know

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

Problem with umlauts and UTF-8
Hello every1,

I'm creating my own little CMS at the moment and got some problems with the cha

Captcha problem users just refresh and it will let them auto submit again
Users will just re submit and not have to enter the new captcha.. ? Lol but if i refresh the page, t

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a

Class not found error
I am getting Class 'index' not found in Eval function:

//write config

$pat

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

login page does not execute a else statement
I've created a login page using sessions.
When an incorrect user name or password is entered then

"From field" in PHP email form
I used a wizard to create a PHP email form. I was able to customize it with the exception of the Fr