Jump to content



  • Please log in to reply
1 reply to this topic

#1 scallywag05

  • Members
  • PipPip
  • Member
  • 14 posts

Posted 24 April 2006 - 03:43 PM

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 [!--coloro:#FF6666--][span style=\"color:#FF6666\"][!--/coloro--]month only[!--colorc--][/span][!--/colorc--] display the data?

#2 michaellunsford

  • Members
  • PipPipPip
  • Advanced Member
  • 1,023 posts
  • LocationLouisiana, USA

Posted 24 April 2006 - 06:30 PM

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'";

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users