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

Odd or Even
Inside of a while loop I need to echo several rows of info...easy enough.

In the loop (for th

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

simple php table loop
Hi all,

I've the following code

<?php // Create category options

Help with email validation please...
Hi,
Please could you help.
I have a register.php login page where users register, the detail

I need help with formatting date from mysql! with php!
Hello guys

*Note: this is a php question not MySQL question, please do not move it to mysql s

Having Problem with Date
l have a submit buttom where user have the possibility to add a date to specify when his message s

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

A problem with my GD class
Hello,

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

Material Issuing for receiving batch
Dear All experts in MM/ PP,

Material issuing from main stores to factory is currently usi