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

mysql VARCHAR acting like INT
Hi, All.

I have a table that contains a varchar(10) column named weird_field. In this column

admin with my register system?
Hey i wana make it so i can make a admin level on my register system , I'm kinda new to php to im no

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

filesize problem
i use ubuntu 9.10 and i have mountet a folder from an windows

/mount/FOLDER
/mount/FOLDER/

highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:

Code: [Select]$mailer = new PHPMailer();
$mailer-&

Help with translating C code into assembler code
Hi im doing a project that moves a robot around a maze avoiding walls and need some help with conver

Help please - How to validate from 2 possible answers
Hi

I hope somebody can help me with what will probably be really simple, I'm pulling my hair

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.