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

No comments posted yet

Your Answer:

Login to answer
159 Like 38 Dislike
Previous forums Next forums
Other forums

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

How do I send data using an html link
Hi

If I have
<a href="main_file.php">

How do I send data t

$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

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

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

sql error
I have been looking at this code for 20mins and can't work out what I am doing wrong. There is somet

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

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