I'm using the following code/query to display the results from a date search. The switch is so when a user clicks on the heading of a column, the fields will resort based on the switch...problem I am having is that I get a blank page when a sort is tried, and I'm sure that it's because the date isn't being passed again...anyway to get the date to keep (I've tried a session) but same problem...thanks
If(isset($POST['month1']))
{
$month1 = $POST['month1'];
$day1 = $POST['day1'];
$year1 = $POST['year1'];
$month2 = $POST['month2'];
$day2 = $POST['day2'];
$year2 = $_POST['year2'];
$date1 = "$month1/$day1/$year1";
$date2 = "$month2/$day2/$year2";
}
?>
<?php
mysql_select_db($database_connWedesign, $connWedesign);
$query_status = "SELECT results.username, results.coursename, results.score, users.name,DATE_FORMAT(results.datestarted,'%m/%d/%y %T') AS date, (results.duration/60),users.employeeid FROM results LEFT JOIN users ON results.username=users.username WHERE DATE_FORMAT(results.datestarted,'%m/%d/%y') >= '$date1' and DATE_FORMAT(results.datestarted,'%m/%d/%y') <= '$date2' ORDER BY '$order'";
$status = mysql_query($query_status, $connWedesign) or die(mysql_error());
$row_status = mysql_fetch_assoc($status);
$totalRows_status = mysql_num_rows($status);
?>
<?
switch ($order) {
case "name":
$order = "name";
break;
case "clock#":
$order = "employeeid";
break;
case "courename":
$order = "coursename";
break;
case "date":
$order = "date";
break;
case "score":
$order = "score";
break;
default:
$order = "name";
break;
} //endswitch
?>
