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

Secure FTP
Hi experts,
There is no SFTP action in MII workbench.
This means it needs developing custo

Allowing ' and "
Hello everyone,

I am creating a form where users submit information to go into a database. I

Php mysql - select?
Hi i have this code:
Code: $iteminfo = mysql_query("SELECT desc FROM wc_items WHERE itemid =

modifying a property of an object from a different class
I have 2 classes:
- Math
- Distance

in my math class, I have this line:
$distance =

some questions
Hello,

I am looking for the answers for following questions:

1) Does PHP support overl

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

value not going in data base
hello friends....
i am having a working javascript....when i am selecting any

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the

How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array..

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