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

generate seo frienly url from a text like wordpress
Convert: "åäö" to "aao", "space" to "-", "!?&q

Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t

LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a

help me fix these syntax errors...
I keep getting multiple syntax errors on this script like this one:

Parse error: syntax error

values in array being escaped
I would like to submit some values - back to the same form for checking before processing...

Not loading image
When this function gets loaded it doesn't load the image just trying to figure out why.

Code:

Move array index to end
Hey guys,
Quick question:

I have an array that looks like this:
Code: [Select]$var =

Taxonomy? Classification? Categorisation?
Not sure if there is a way around this classification problem
I have a supplier who produces

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names