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

Code clarification
Hi

In the following code what could be the "search_print()" and where it could be

pagination numbering pattern
Hello,

I have following code which works great for pagination. but i have small issue now.

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

PHP & Images [Resize, Crop, Save]
Hey! Well I have a little dilema, hoping I could find some guidance.

I have a CMS and on the

noob question
i traying to do a php form with auto replay for both(me and the user who send me a mail),

a u

PHP Form to Variable.
Hi! I have written a HTML-form code in DreamWeaver CS3 (in a PHP doc) and I really need it to work s

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

Reditecting pages based on logic
Newbie here, apologies in advance!

I am trying to use the header function to forward one of a

Get value from Select menu
Hi!

Have tried to find the solution on the web. Don't know if there is an easy one. A descrip

turning an array into a string then poping it into a db
Hi im just wondering how you get a requested array into a single string then pop it into the db so f

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