Jump to content

Arrays


scallywag05

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?
Link to comment
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'";
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.