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

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

How to Handle more than one submit button in single form?
Hi
I have one PHP file which contains one Form. In this form there are two Submit type Buttons

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.


Problem in OnClientClick and OnClick sync
Hi,Strange and irritating problem: I have below button declaration in markup of the aspx page:

Sharing PHP Sessions Across Domains
I am in the process of writing a script to share a php session across various domains I have.
The

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

PHP Thumbnail Creation
Ok so i use this function to create thumbnails:

Code: [Select]function createthumb($name,$fil

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