Jump to content


This topic is now archived and is closed to further replies.



Recommended Posts

Hi i need to initialise an array of months and days of the month so that when a user chooses a specific month an sql query runs selecting data from the database about the specified month ie:

$month =(1=>"january"...................)

$sql = Select * from table where username=$username and date='2006-MONTH-'

the data is stored in the database in this form '2006-M-D', how do i depending on [b][!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]month only[!--colorc--][/span][!--/colorc--][/b] display the data?

Share this post

Link to post
Share on other sites
I'm no mysql expert -- but the mysql refman 4.1 has an enlightening example on page 216

This is untested, so you will probably need to tweak the following syntax to make it work for you:

$sql = "SELECT * FROM `table` WHERE `username`='$username' AND MONTH(`date`)='$month_variable'";

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.