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

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use

CURL XML Request [From C to PHP]
Hi,

I need some help converting this into something that will work with PHP.

Code: #

a dificult string search
Hi I don't know a way around this. I want the user to input a password, but to make it a bit complca

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

Check before inserting in DB ???
This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

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

Can php detect connection speed and thereafter swap out elements?
No code to post, lads, yet. Just looking for a yay or nay at this stage:

Can a php script be