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 would I convert this into code using an if statement?
ES equals exam score m equals $mean s equals $total. I already coded my mean and total so I'm not g

imap: how to save a copy of sent emails to sent elements
Hello my friends,

I am writing an online emailing application with inbox outbox/sent elements

array ...
hi
Code: function formatCategories($categories, $parentId)
{
// $navCat stores all child

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

* Gridview and Detailsview in UpdatePanel, insert mode problem
I have a GridView and DetailsView working together. When a record from Gridview is selected, Detail

foreach help.
Hello all,

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

restricting another login once you logout
Hello,

how can I restrict a page from login authenticating against info in a MySQL DB for a s

how make 2 column in table with data tybe long row
hi every one

I want make in my table 2 column with data tybe long raw

how thi

Install page
How do I make it so when a user submits information on the Install page, it'll right it into the cor

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html