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

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

Members Only
Hi all, for my website i have a members area only which on members can veiw, but at the moment anyon

INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc

unoconv doc convert to pdf code prob
PHP/5.3.1

Hi. I am trying to use this code to convert docs to .pdf utilizing unoconv. Howe

Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line

PHP, Arrays & A Lot Of Confusion
I've been doing basic PHP work on sites for a few years now, but I've never been tempted to learn ho

Array help
Hello i got this code to fetch data from database but it is not working it displays
7
Array

Users and Groups with PHP Classes
Hi,

I have setup what I hope to be a good working User class. Now I want to introduce group m

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a