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

jquery validation in codeIgniter
hai i need to add client side validation to my fiels which are selected in a forloop.the fields are

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I

Are sessions secure at all?..
I haven't really gotten into yet, but I was just thinking of something weird..

Lets say you h

Filename like the user name
I am creating a form and storing the values in file. Could anyone please tell me how to write a code

Linux socket programming
Where can I find a good introduction to socket programming?

problems with search form numerical "between" sending by php
I am trying to display the results of a search, on a sql database, on a web page. I set up html &quo

Convert .fdf to .pdf
I currently have a web form that uploads the form data to an .fdf file and emails it.

However

Create multiple (n) arrays
Hi there,

I have the following need:

I have 2 arrays (coming from a databases)

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

losing session vars when arriving from an email link
Hi,

I've got a confirmation script made that sends an email with a link for a user to confirm

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