Stuff

<?php// top 10 information (shot via ajax)         $radioWaste  = $_GET["radioWaste"];$radioMeters = $_GET["radioMeters"];$radioEff    = $_GET["radioEff"];$toggle      = $_GET["toggle"];$timeFrame   = $_GET["timeFrame"];$submit      = $_GET["submit"];// date control$date = mktime();$year   = strftime("%Y", $date);$month  = strftime("%m", $date);$day    = strftime("%d", $date);          $startDate  = mktime(22, 0, 0, $month, $day, $year);if ($timeFrame == "last30Days")  $startDate = strtotime(strftime("%c",$startDate)." - 30 days");elseif ($timeFrame == "last3Months")  $startDate = strtotime(strftime("%c",$startDate)." - 3 months");elseif ($timeFrame == "last12Months")  $startDate = strtotime(strftime("%c",$startDate)." - 12 months");$endDate    = mktime(24, 0, 0, $month, $day, $year);         $where = "`timeSubmitted` BETWEEN $startDate AND $endDate";          // column, order by and group by control$column = "";$order  = "";$group  = "";          if ($submit == "line")  $column = "mil";elseif ($submit == "product")  $column = "product";elseif ($submit == "group")  $column = "productGroup";elseif ($submit == "shift")  $column = "shift";$group = $column;  if ($radioWaste == "true") {  $column .= ",SUM(wasteProd)";  $order   = "SUM(wasteProd)";} elseif ($radioMeters == "true") {  $column .= ",SUM(meters)";  $order   = "SUM(wasteProd)";} elseif ($radioEff == "true") {  $column .= "SUM(eff)/count(eff) as eff";  $order   = "eff";  $where  .= " AND eff <> 0";}// sort control$sort = "";if ($toggle == "most")  $sort = "DESC";if ($toggle == "least") $sort = "ASC";                 $sql = "SELECT $column FROM `allproducts` WHERE $where GROUP BY $group ORDER BY $order $sort LIMIT 0,10";echo "<br>$sql<br>";?>