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

HTML Form Server Side Validation
Hi, Im new here, im currently doing a website for a friend, and I have designed using snippets from

Move array index to end
Hey guys,
Quick question:

I have an array that looks like this:
Code: [Select]$var =

Custom Container in module pool program
Hello everyone,

I have created a custom control in my module pool screen. Now I want to s

Match stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

scandir clients directory
hi,
how can i scandir the clients directory? i need a script that when i click a button it will u

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Get Total From While Loop
I'm trying to get the total for each product and add them for a Grand Total to list outside the loop

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

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

controlling/creating accounts with privileges
hi all,
i'm trying to figure out how i can create/control account with privileges, for instance a