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

please, need help coding this voting for your favorite car polling system.
hi, my code needs a lot of work, but i want to be able to let users vote on their favorite car, upda

upload only text files
hi guys i want to upload only text like like (pdf,note pad and ofiice files) so can any one please t

progress bar...need expert opinion of experienced webmaster
Hey guys, quick question:

I want to display a progress bar when I upload files, but I am not

exclude characters from counting?
Hello, I wanted to ask if you have a string like:
Code: $my_s='ASRGREGTGTR----REGREGRE+++RRRRRR..

Custom list order
Hi there,

I have checked this tutorial and it's great till the point where I want to display

Dynamic Data + Sql Server 2005 Enterprise?
Hi! I have just started to learn ASP.NET, and it looks like it is quite a lot to learn. Im not reall

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

Opening Multiple Files/Links in Order.
I want to open links in order/one-by-one and check each for a specific string.

Example:
I

quick question
Hi ..

i have a question
how do i set a var so it displays via an echo
Code: $logo = '&a

Page doesn't expand for content
Hi. I've been testing a query I made. It's here http://lapr1.6te.net/inquerito.php
The page doesn