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

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

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

if($textbox == 'unchang

Please help - should be a simple fix.. driving me nuts
Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and

Calling a Procedure with IN & OUT Parameters
Hello,

I usually call my procedures using the following way

declare variable e

SAP Logon Failed
I tried to login to SAP through MMC.

When i click start and give password.

it

fwrite error
Hi All,
Does anyone know what is causing the error in this code?

Code: <?
$error

How to change Time Zone
HI
I want to change the time zone of the server to another country.How can do that?

Thanks

Unable to retreve the values from Mysql Query
Hi,

Here is the php code that I have, Query is running properly in phpmyadmin and is resu