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

Post PHP form to non-existing page
The company that I work for host their PHP code on IIS on a Windows server, no Apache, so no mod_rew

limit string by words??
hello all,

I was wonder if there is a function to limit a string by the number of words inste

SESSION CHECK WORKS "MOST" of the time... whats going on?
i have a sign in check thats included in every page that is a members only page which is basically a

Embed Video Problem
Hey, thanks for looking!

File to be embedded:

Code: <playlist version="1&q

New to PHP and just trying to understand a little code.
I hope I'm not annoying anyone or breaking the rules but I was wondering about this bit of code righ

Firewall / visited websites logger
Hi. I have a firewall implementation and I want to log all the websites visited on the machine. S

tag inside php...
hi


Code: <?php
echo "<td width="$columnWidth%" align=&

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

a multi dimensional array with for each
hi, I have been asked to write an array, I have Zone 2,3,4,5,6,7,8 each zone has 3 sections of weigh

problems with search form numerical "between" sending by php
I am trying to display the results of a search, on a sql database, on a web page. I set up html &quo