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

Strange array issue, never happened before.
mysql_fetch_array returns 1 array per call. Generally that's why it is inserted into a while statem

Is it possible to stop reservation creation in PM Order?
Hi All,

Is it possible to stop reservation creation in PM Order?

Thanks in adv

how to get IP address?
hey guys,

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

Post, not working, please help
The error is:
Method Not Allowed
The requested method POST is not allowed for the URL /student

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

Multiple arrays inside data
Hi,

Simple question. I have a column called "array" in my database, and inserted in

Format String help
I have a textbox where a person enters an application number. the application number is 10 characte

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec

Count on multidimensional array
Hi, i got an array as below:

Array
(
=> Array
(

problems with php variables in mysql query
i can't seem to get the following query to work.

select $q1c from $vote_rate where id = $re