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

textfield unchanged
hi,
i want my form to know whether its textbox is unchange or not.

if($textbox == 'unchang

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Need help making a blockquote and line items conditional
I have some code I bought a few years ago that allows my clients to update content on their site usi

redirect standard error and assert (how to?)
How do you redirect standard error and assert?

---

(Why? I am creating an web app and

Creating a function
Basically i wanna put all this code in a seperate file

Code: <?php

Server side $_SESSION
how does one keep the session completely server side. no cookies to the browser at all. i need this

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.

fie

how to get IP address?
hey guys,

i have this code which is supposed to get me the IP address of my site visitors:

Add 5 to a variable when a button is clicked, and re-run a for loop
So I'm making a feedback sort of section on a website with MySQL and PHP, I've gotten the script to

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