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);

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

problem with sql querry in php script
Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

Displaying Site Logo/Icon on a Title tag
really need some help out here. I want to insert a Logo/Icon just like the one close to the "PH

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

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