Hi there:
I'm stil having problems with this query in that it doesn't bring up any results!
Here is the <select> menu that refreshes the page and deposites the var: 'sortedBy'
into play:
<form>
<select name=\"sortMonth\" onChange=\"MM_jumpMenu('parent',this,0)\";>
<option>--select one--</option>
<option value=\"$PHP_SELF?sortedBy=Jan\">Jan</option>
<option value=\"$PHP_SELF?sortedBy=Feb\">Feb</option>
<option value=\"$PHP_SELF?sortedBy=Mar\">Mar</option>
<option value=\"$PHP_SELF?sortedBy=Apr\">Apr</option>
<option value=\"$PHP_SELF?sortedBy=May\">May</option>
<option value=\"$PHP_SELF?sortedBy=Jun\">Jun</option>
<option value=\"$PHP_SELF?sortedBy=Jul\">Jul</option>
<option value=\"$PHP_SELF?sortedBy=Aug\">Aug</option>
<option value=\"$PHP_SELF?sortedBy=Sep\">Sep</option>
<option value=\"$PHP_SELF?sortedBy=Oct\">Oct</option>
<option value=\"$PHP_SELF?sortedBy=Nov\">Nov</option>
<option value=\"$PHP_SELF?sortedBy=Dec\">Dec</option>
</select>
</form>
The SQL qery:
if(
($sortedBy == 'Jan') || ($sortedBy == 'Feb') || ($sortedBy == 'Mar') ||
($sortedBy == 'Apr') || ($sortedBy == 'May') || ($sortedBy == 'Jun') ||
($sortedBy == 'Jul') || ($sortedBy == 'Aug') || ($sortedBy == 'Sep') ||
($sortedBy == 'Oct') || ($sortedBy == 'Nov') || ($sortedBy == 'Dec')
)
{
$sql = "SELECT * FROM $table_cal WHERE item_activity='$id' AND
DATE_FORMAT('item_date','%b')='$sortedBy'";
}
Thanks to Rasmus for helping me out so far!
Can anyone see what I may be doing wrong???
I'm using mysql-3.22.32 and the item_date column is a MySQL DATE() column..
Cheers:
Russ
#-------------------------------------------------------#
"Believe nothing - consider everything"
"Web Developers do it on-the-fly."
Russ Michell
Anglia Polytechnic University Webteam
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x 2331
www.theruss.com
#-------------------------------------------------------#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]