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!

Did you know?Explore Trending and Topic pages for more stories like this.
Thanks
No comments posted yet

Your Answer:

Login to answer
159 Like 38 Dislike
Previous forums Next forums
Other forums

Parse Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen

CE 7.1 and External GIS integration
Hi All,

We want to develop an application on CE 7.1 which uses GIS features from an exter

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

Getting the full city list from maxminds geoip database
I am suprised I can't find any references to this.

I have maxminds geoip lite installed and i

why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

Server side $_SESSION
how does one keep the session completely server side. no cookies to the browser at all. i need this

CHECK A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash