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

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t

Opening Multiple Files/Links in Order.
I want to open links in order/one-by-one and check each for a specific string.

Example:
I

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

disable all input buttons
Hello Friends,

suppose i do have a file ( file.php ) has a submit button

Code: [Sele

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/

In a nutshe

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are