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

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri

Insert to MySQL inside foreach
Hey.
I am parsing some html, and putting inside an html db.
I need to create a randomized inte

Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

Simple AND question
Hello,

I've got following code:

Code: if(strpos($row[13],"http://")

include function being weird?
I have a very simple system to grab an IP outputted by a PHP file.. (for a project I have) but it ou

Exporting new records
Trying to figure out the best way to set this up.

People register my site.

Their prof

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext

Help with some dates
I have a list of dates in an array:

$mondays = array(
strtotime("October 12, 2009

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i