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

problems with script
I made a small script wich exchanges points in my website:


<?php
session_start

Splitting Attributes
SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, IN

add 20 000 to the rowcnt
Hi ...
I need to add 20 000 to the row count but just cant find a way to do this i am new to php

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

Request for tunning the below query
Hi,

Can any one help me on the below query while improving the performance,

PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

Help me with some material on Open Text Overview.
Hi Experts,
Please help me out with some material on Open Text. I have been supporting AP Workf

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

unexpected T_STRING
error log "[Sat Jan 09 18:27:58 2010] [error] [client 127.0.0.1] PHP Parse error: syntax error

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