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

cPanel API
Hi Guys,

Need a little guidance. I'm trying to get my script to communicate with cPanel (or W

Certain files upload, while others do not
I want to read the data from an uploaded file. Not sure why, but it only uploads for certain files.

Else statement screws up all css
Does anyone know what goes wrong in the process with this php code?
This code seems to be causing

Upload Code Help
Hi everyone I need some help with a bit of code ive been working with for a while. I am completely s

Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, IN

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

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

Wordpress IE issue
So I am trying to add the background shadow to my wordpress page. It works fine in Firefox but does

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