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

No comments posted yet

Your Answer:

Login to answer
159 Like 38 Dislike
Previous forums Next forums
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

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