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

insert mysql embeded videos as blobs?
Using TinyMCE my client will be able to embed images and flash videos into large columns of text whi

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Multiple while loops
I have several DB queries that I know should be returning results and aren't. I have a feeling it ha

How to make a mail Form secure?
I want to create an email Form on my web site. How can I make the Form secure so the submitted info

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

Last Weeks sDate and eDate.
sDate - Start Date
eDate - End Date

I need to pull two dates for "Last Week" whi

Pipe email to PHP - get mail adress from MySQL - send?
Hi all,

this is the challenge:

1) Our faculty at the college where I'm employed includ

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

Unidentified index error in a simple form
I have been trying to make an HTML form that is handled by a PHP script. So far my attempts to get i

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