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

How can you detect variable string in a massive string?
Ok guys, i need some help with this one.

I am going to be getting a large string, like 10-20

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

foreach help.
Hello all,

First time I'm attempting to use a foreach statement and was just wondering if my

Showing selected item at top of list
Hi,

I've got a list of names which i am fetching from database like this:
$qry = db_query

validating url
im trying to validate url's sent to me by a form
the url's im collecting are for placing banners

Save cookie to DB
I'm working on a pixel tracking script for an incentive website and I need to use an ASP script to s

$_FILES array
Ok,

I just started experimenting with PHP today. My goal right now is to have people be able

Interpret Order
Hello all,

I'm wondering if I have this:

Code: $switch = array(
'one' =>

I need an iframe that calls up a different page according to the date
hi

I don't know any php (only html) and I urgently need to do the following:

I need a