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

Why doesn't this work? (SSH2)
This is my script:

Code: <?php
$connection = ssh2_connect('213.251.167.109', 22);

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

xml element exists
Code: [Select]<?xml version="1.0"?>
<Addresses>
<

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

How to search for several parameters from objects in a database?
I have a database with lots of information about objects.
Now I would like to search for 4 or 5 p

Drop Down and text box issue
Is it possible to set a drop down list and text boxes to a certain width?

here is my code

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

Forgot password won't work
My forgot password thing is not working properly. It is giving me this errorMailbox unavailable. The

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

Need help in log in and log out?
hi there all of u. i have recently created a site for someone. i have placed log in and log out and

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