How do I display my data like this in PHP?

<?php
function qs_string_to_timestamp($str)
{
  $l=strlen($str);
  switch ($l) {
    case  4:
        $tm=qs_year_to_timestamp($str);
	    break;
 
	case  8:
        $tm=qs_time_to_timestamp($str);
	    break;
	
	case 10:
        $tm=qs_date_to_timestamp($str);
        break;
	
	case 14:
        $tm=qs_timestamp_to_timestamp($str);
	    break;
    
	case 19:
        $tm=qs_datetime_to_timestamp($str);
        break;	 
 
	case 23:
        $tm=qs_datetime_to_timestamp($str);
        break;
 
    default:
        $tm=mktime(24,0,0,1,1,1970);
  }
  return $tm;
}
 
function qs_timestamp_to_timestamp($dt) 
{ 
  $yr=strval(substr($dt,0,4)); 
  $mo=strval(substr($dt,4,2)); 
  $da=strval(substr($dt,6,2)); 
  $hr=strval(substr($dt,8,2)); 
  $mi=strval(substr($dt,10,2)); 
  $se=strval(substr($dt,12,2)); 
 
  return mktime($hr,$mi,$se,$mo,$da,$yr); 
} 
 
function qs_datetime_to_timestamp($dt) 
{ 
  $yr=strval(substr($dt,0,4)); 
  $mo=strval(substr($dt,5,2)); 
  $da=strval(substr($dt,8,2)); 
  $hr=strval(substr($dt,11,2)); 
  $mi=strval(substr($dt,14,2)); 
  $se=strval(substr($dt,17,2)); 
 
  return @mktime($hr,$mi,$se,$mo,$da,$yr); 
} 
 
function qs_date_to_timestamp($dt) 
{ 
  $yr=strval(substr($dt,0,4)); 
  $mo=strval(substr($dt,5,2)); 
  $da=strval(substr($dt,8,2)); 
  $hr=0; 
  $mi=0; 
  $se=0; 
 
  return mktime($hr,$mi,$se,$mo,$da,$yr); 
} 
 
function qs_time_to_timestamp($dt) 
{ 
  $yr=1970; 
  $mo=1; 
  $da=1; 
  $hr=strval(substr($dt,0,2)); 
  $mi=strval(substr($dt,3,2)); 
  $se=strval(substr($dt,6,2));
 
  return mktime($hr,$mi,$se,$mo,$da,$yr); 
} 
 
function qs_year_to_timestamp($dt) 
{ 
  $yr=strval(substr($dt,0,4)); 
  $mo=1; 
  $da=1; 
  $hr=0; 
  $mi=0; 
  $se=0; 
 
  return mktime($hr,$mi,$se,$mo,$da,$yr); 
} 
 
function qs_datetime_to_string ($dt)
{
  if (date("H:i:s",$dt) == "00:00:00") {
    $str = date("n/j/Y",$dt);
  } else {
    $str = date("n/j/Y g:i:s",$dt);
  }	  
  return $str; 
}
 
function qsvalid_timestamp($dt) 
{ 
  if (strlen($dt) == 14) { 
    $retval = is_numeric($dt); 
  } else {
    $retval = false;
  }
  return $retval; 
} 
 
function qsvalidrequest ($paramval)
{
  return (((isset($_GET[$paramval])) || (isset($_POST[$paramval]))) && (qsrequest($paramval)!=""));
}
 
function qsrequest ($paramval)
{
  if (isset($_GET[$paramval])) {
      $retval = $_GET[$paramval];  
  } elseif (isset($_POST[$paramval])) {
      $retval = $_POST[$paramval];
  } else {
      $retval = "";
  }
  return $retval;
}
 
function qsservervars($paramval)
{
  if (isset($_SERVER[$paramval])) {
      $retval = $_SERVER[$paramval];  
  } else {
      $retval = "";
  }
  return $retval;
}
 
function qssession($paramval)
{
  if (isset($_SESSION[$paramval])) {
      $retval = $_SESSION[$paramval];  
  } else {
      $retval = "";
  }
  return $retval;
}
 
function arrayvalue($paramval,$search_array)
{
  if (array_key_exists($paramval,$search_array)) {
      $retval = $search_array[$paramval];
  } else {
      $retval = "";
  }
  return $retval;
}
 
function qsodbc_fetch_array($res,$row_num) 
{                     
  $row = array(); 
  $result = array(); 
  if ($row_num > 0) {
    $result = odbc_fetch_row($res,$row_num);
  } else {
    $result = odbc_fetch_row($res);
  }
  if ($result) { 
    $nf = odbc_num_fields($res);       
    for($i=0; $i < $nf; $i++) { 
      $field_value = odbc_result($res, $i + 1); 
      $row[$i] = $field_value; 
    } 
    return $row;                 
  } 
} 
 
function qsodbc_num_rows($res)
{
  $rowcount = odbc_num_rows($res);
  if ($rowcount < 0) {
    $rowcount = 0;
    while($temp = odbc_fetch_into($res,&$idata)){
      $rowcount++;
    }
  }
  return $rowcount;
}
 
function qscheckselected ($paramval, $itemval, $defaultval)
{
  if (trim(strtoupper($paramval)) == trim(strtoupper($itemval))) {
      $retval = $defaultval;     
  } else {
      $retval = "";
  }   
  return $retval;
}
 
function qsmysqlgen_radio_button($sql,$objname,$field1,$field2,$itemval)
{
  $result  = mysql_query($sql) or die("Invalid query");
  $cellstr = ""; 
  while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    $cellstr .= "<input type=\"radio\" name=\""; 
	$cellstr .= $objname . "\" value=\"" . $row[$field1] . "\"";
	$cellstr .= qscheckselected($row[$field1],$itemval,"Checked") . ">";
    $cellstr .= $row[$field2] . "<br>";
  }
  mysql_free_result($result);
  return $cellstr;
}
 
function qsmysqlgen_listbox($sql,$objname,$field1,$field2,$itemval)
{
  $result  = mysql_query($sql) or die("Invalid query");
  $cellstr = "";
  while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
  	$cellstr .= "<option value=\"" . $row[$field1] . "\"";
	$cellstr .= qscheckselected($row[$field1],$itemval,"Selected") . ">";
    $cellstr .= $row[$field2] . "</option>"; 
  }
  mysql_free_result($result);
  return $cellstr;
}
 
function qsodbcgen_radio_button($conn,$sql,$objname,$field1,$field2,$itemval)
{
  $result = odbc_exec($conn,$sql) or die("Invalid query");
  $cellstr = ""; 
  while (odbc_fetch_row($result)) {
    $cellstr .= "<input type=\"radio\" name=\""; 
	$cellstr .= $objname . "\" value=\"" . odbc_result($result,$field1) . "\"";
	$cellstr .= qscheckselected(odbc_result($result,$field1),$itemval,"Checked") . ">";
    $cellstr .= odbc_result($result,$field2) . "<br>";
  }
  odbc_free_result($result);
  return $cellstr;
}
 
function qsodbcgen_listbox($conn,$sql,$field1,$field2,$itemval)
{
  $result  = odbc_exec($conn,$sql) or die("Invalid query");
  $cellstr = "";
  while (odbc_fetch_row($result)) {
  	$cellstr .= "<option value=\"" . odbc_result($result,$field1) . "\"";
	$cellstr .= qscheckselected(odbc_result($result,$field1),$itemval,"Selected") . ">";
    $cellstr .= odbc_result($result,$field2) . "</option>"; 
  }
  odbc_free_result($result);
  return $cellstr;
}
 
function qsreplace_html_quote($itemval)
{
  $retval = htmlspecialchars($itemval, ENT_QUOTES);
  return $retval;
}
 
function qsreplace_quote($itemval)
{
  $retval = addslashes($itemval);
  return $retval;
}
 
function qsreplace_backslashes($itemval)
{
  $retval = str_replace("\\","\\\\",$itemval);
  return $retval;
}
 
function qsdestroysession()
{
  $_SESSION = array(); 
  session_destroy();
}
?>

Select allOpen in new window

<?php
require('conn.php');
require('func.php');
@session_start();
$err_string = "";
$strkeyword = "";
$sortstring = "";
$sql = "";
$sql_ext = "";
$fields = array();
$fields[0] = "master.`id`";
$fields[1] = "master.`division`";
$fields[2] = "master.`location`";
$fields[3] = "quota.`id`";
$fields[4] = "quota.`quota`";
$arryitemvalue = array();
$arryitemvalue[0] = "";
$arryitemvalue[1] = "";
$arryitemvalue[2] = "";
$arryitemvalue[3] = "";
$arryitemvalue[4] = "";
$arryitemvalue[5] = "";
$arryitemvalue[6] = "";
$arryitemvalue[7] = "";
$arryitemvalue[8] = "";
$arryitemvalue[9] = "";
$arryitemvalue[10] = "";
$arryitemvalue[11] = "";
$arryitemvalue[12] = "";
$arryitemvalue[13] = "";
$arryitemvalue[14] = "";
$arryitemvalue[15] = "";
$arryitemvalue[16] = "";
$arryitemvalue[17] = "";
$arryitemvalue[18] = "";
$arryitemvalue[19] = "";
$arryitemvalue[20] = "";
$arryitemvalue[21] = "";
$arryitemvalue[22] = "";
$arryitemvalue[23] = "";
$arryitemvalue[24] = "";
$arryitemvalue[25] = "";
$arryitemvalue[26] = "";
$arryitemvalue[27] = "";
$arryitemvalue[28] = "";
$arryitemvalue[29] = "";
$arryitemvalue[30] = "";
$arryitemvalue[31] = "";
$arryitemvalue[32] = "";
$arryitemvalue[33] = "";
$arryitemvalue[34] = "";
$arryitemvalue[35] = "";
$arryitemvalue[36] = "";
$arryitemvalue[37] = "";
$arryitemvalue[38] = "";
$arryopt = array();
$arryopt[0] = "";
$arryopt[1] = "";
$arryopt[2] = "";
$arryopt[3] = "";
$arryopt[4] = "";
$arryopt[5] = "";
$arryopt[6] = "";
$arryopt[7] = "";
$arryopt[8] = "";
$arryopt[9] = "";
$arryopt[10] = "";
$arryopt[11] = "";
$arryopt[12] = "";
$arryopt[13] = "";
$arryopt[14] = "";
$arryopt[15] = "";
$arryopt[16] = "";
$arryopt[17] = "";
$arryopt[18] = "";
$arryopt[19] = "";
$arryopt[20] = "";
$arryopt[21] = "";
$arryopt[22] = "";
$arryopt[23] = "";
$arryopt[24] = "";
$arryopt[25] = "";
$arryopt[26] = "";
$arryopt[27] = "";
$arryopt[28] = "";
$arryopt[29] = "";
$arryopt[30] = "";
$arryopt[31] = "";
$arryopt[32] = "";
$arryopt[33] = "";
$arryopt[34] = "";
$arryopt[35] = "";
$arryopt[36] = "";
$arryopt[37] = "";
$arryopt[38] = "";
$sql .= " Select";
$sql .= "     master.`id`,";
$sql .= "     master.`division`,";
$sql .= "     master.`city`,";
$sql .= "     quota.`id`,";
$sql .= "     quota.`quota`,";
$sql .= " From";
$sql .= "     master   master,";
$sql .= "     quota   quota,";
$sql .= " Where (";
$sql .= "            master.id = quota.id";
$sql .= " )";
$sql .= "  ";
 
$sql_ext .= " ORDER BY master.id ASC";
 
$result = mysql_query($sql . " " . $sql_ext . " limit 0,1")
          or die("Invalid query");
if (isset($_POST["QS_Submit"])) {
    $filter_string = "";
    $qry_string = "";
    $i = 0;
    while ($i < mysql_num_fields($result)) {
        $meta = mysql_fetch_field($result);
        $field_name = $meta->name;
        $field_type = $meta->type;
        if ((qsrequest("search_fd" . $i) != "") && (qsrequest("search_fd" . $i) != "*")) {
            $idata = qsrequest("search_fd" . $i);
            if (strlen($idata) > 1) {
                if ($idata[strlen($idata) - 1] == "*") {
                    $idata = substr($idata, 0, strlen($idata) - 1);
                }
            }
            $idata = str_replace("*", "%", $idata);
            $irealdata = $idata;
            if (qsrequest("search_optfd".$i) != "") {
              $idata = qsrequest("search_optfd". $i) . $idata ;
            }
            $iopt = substr($idata, 0, 2);
            if (($iopt == "<=") || ($iopt == "=<")) {
                $iopt = "<=";
                $irealdata = substr($idata, 2);
            } elseif (($iopt == ">=") || ($iopt == "=>")) {
                $iopt = ">=";
                $irealdata = substr($idata, 2);
            } elseif ($iopt == "==") {
                $iopt = "=";
                $irealdata = substr($idata, 2);
            } elseif ($iopt == "<>") {
                $irealdata = substr($idata, 2);
            } elseif ($iopt == "^^") {
                      $iopt = "*";
            	$idata =  $iopt . $irealdata . $iopt; // Contain
                  } elseif ($iopt == "^*") {
                      $iopt = "*";
            	$idata =  $irealdata . $iopt; // Start With
                  } elseif ($iopt == "*^") {
                      $iopt = "*";
            	$idata =  $iopt . $irealdata ; // End With
            } else {
                $iopt = substr($idata, 0, 1);
                if (($iopt == "<") || ($iopt == ">") || ($iopt == "=")) {
                    $irealdata = substr($idata,1);
                } else {
                    $iopt = "=";
                }
            }
        if (!strcasecmp($idata,"{current date and time}")) {
            $idata = time();
        } elseif (!strcasecmp($idata,"{current date}")) {
            $idata = time();
        } elseif (!strcasecmp($idata,"{current time}")) {
            $idata = time();
        }
            if ($meta) {
                if ((strtolower($field_type) == "timestamp")
                  ||(strtolower($field_type) == "datetime")
                  ||(strtolower($field_type) == "smalldatetime")
                  ||(strtolower($field_type) == "date")
                  ||(strtolower($field_type) == "time")
                  ||(strtolower($field_type) == "year")) {
                    if ((($timestamp = strtotime($irealdata)) !== -1)) {
                        if ($qry_string == "") {
                            $qry_string = "search_fd" . $i . "=" . urlencode($idata);
                            $filter_string = $field_name . " " . $iopt . " '" . $irealdata . "'";
                        } else {
                            $qry_string .= "&search_fd" . $i . "=" . urlencode($idata);
                            $filter_string .= " and " . $field_name . " " . $iopt . " '" . $irealdata . "'";
                        }
                    } else {
                        $err_string .= "<strong>Error:</strong>while searching.<strong>" . $field_name . "</strong>.<br>";
                        $err_string .= "Description: Invalid DateTime.<br>";
                    }
                } elseif (($meta->numeric) == 1) {
                    if (is_numeric($irealdata)) {
                        if ($qry_string == "") {
                            $qry_string = "search_fd" . $i . "=" . $idata;
                            $filter_string = $field_name . " " . $iopt . " " . $irealdata;
                        } else {
                            $qry_string .= "&search_fd" . $i . "=" . $idata;
                            $filter_string .= " and " . $field_name . " " . $iopt . " " . $irealdata;
                        }
                    } else {
                        $err_string .= "<strong>Error:</strong>while searching.<strong>" . $field_name . "</strong>.<br>";
                        $err_string .= "Description: Type mismatch.<br>";
                    }
                } elseif ((strtolower($field_type) == "blob")
                        ||(strtolower($field_type) == "mediumblob")
                        ||(strtolower($field_type) == "longblob")) {
                    if ($qry_string == "") {
                        $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string = $field_name . " like '%" . $irealdata . "%'";
                    } else {
                        $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string .= " and " . $field_name . " like '%" . $irealdata . "%'";
                    }
                } elseif ((strtolower($field_type) == "varchar")
                        ||(strtolower($field_type) == "char")
                        ||(strtolower($field_type) == "text")
                        ||(strtolower($field_type) == "tinytext")
                        ||(strtolower($field_type) == "mediumtext")
                        ||(strtolower($field_type) == "string")
                        ||(strtolower($field_type) == "longtext")
                        ||(strtolower($field_type) == "nvarchar")
                        ||(strtolower($field_type) == "nchar")
                        ||(strtolower($field_type) == "ntext")) {
                    if ($qry_string == "") {
                        $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string = $field_name . " like '" . $irealdata . "%'";
                    } else {
                        $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string .= " and " . $field_name . " like '" . $irealdata . "%'";
                    }
                } else {
                    if ($qry_string == "") {
                        $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string = $field_name . " = '" . $irealdata . "'";
                    } else {
                        $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string .= " and " . $field_name . " = '" . $irealdata . "'";
                    }
                }
            }
        }
        if (qsrequest("multisearch_fd" . $i) != "") {
            if ($qry_string == "") {
                $qry_string = "multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
            } else {
                $qry_string = $qry_string . "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
            }
        }
        if (qsrequest("search_fd_" . $i) != "") {
            $idata = qsrequest("search_fd_" . $i);
            if (strlen($idata) > 1) {
                if ($idata[strlen($idata) - 1] == "*") {
                    $idata = substr($idata, 0, strlen($idata) - 1);
                }
            }
            $idata = str_replace("*", "%", $idata);
            $irealdata = $idata;
            if (qsrequest("search_optfd_".$i) != "") {
                $idata = qsrequest("search_optfd_". $i) . $idata ;
            }
            if ($meta) {
                if ((strtolower($field_type) == "timestamp")
                   ||(strtolower($field_type) == "datetime")
                   ||(strtolower($field_type) == "smalldatetime")
                   ||(strtolower($field_type) == "date")
                   ||(strtolower($field_type) == "time")
                   ||(strtolower($field_type) == "year")) {
                   if ((($timestamp = strtotime($irealdata)) !== -1)) {
                       if ($qry_string == "") {
                           $qry_string = "search_fd_" . $i . "=" . urlencode($idata);
                           $filter_string = $field_name . " like '%" . $idata . "%'";
                       } else {
                           $qry_string .= "&search_fd_" . $i . "=" . urlencode($idata);
                           $filter_string .= " and " . $field_name . " like '%" . $idata . "%'";
                       }
                   } else {
                       $err_string .= "<strong>Error:</strong>while searching.<strong>" . $field_name . "</strong>.<br>";
                     $err_string .= "Description: Invalid DateTime.<br>";
                   }
               } elseif ((strtolower($field_type) == "integer")
                   ||(strtolower($field_type) == "int")
                   ||(strtolower($field_type) == "smallint")
                   ||(strtolower($field_type) == "tinyint")
                   ||(strtolower($field_type) == "longint")
                   ||(strtolower($field_type) == "counter")
                   ||(strtolower($field_type) == "autoincrement")
                   ||(strtolower($field_type) == "float")
                   ||(strtolower($field_type) == "real")
                   ||(strtolower($field_type) == "money")
                   ||(strtolower($field_type) == "smallmoney")
                   ||(strtolower($field_type) == "short")
                   ||(strtolower($field_type) == "long")
                   ||(strtolower($field_type) == "double")
                   ||(strtolower($field_type) == "currency")
                   ||(strtolower($field_type) == "bit")
                   ||(strtolower($field_type) == "decimal")
                   ||(strtolower($field_type) == "number")
                   ||(strtolower($field_type) == "numeric")) {
                   if (is_numeric($irealdata)) {
                       if ($qry_string == "") {
                           $qry_string = "search_fd_" . $i . "=" . $idata;
                           $filter_string = $field_name . " " . $iopt . " " . $irealdata;
                       } else {
                           $qry_string .= "&search_fd_" . $i . "=" . $idata;
                           $filter_string .= " and " . $field_name . " " . $iopt . " " . $irealdata;
                       }
                   } else {
                        $err_string .= "<strong>Error:</strong>while searching.<strong>" . $field_name . "</strong>.<br>";
                        $err_string .= "Description: Type mismatch.<br>";
                   }
               }
           }
        }
        $i++;
    }
    if ($result > 0) {mysql_free_result($result);}
  if (qsrequest("search_sort") <> "") {
	    $sortstring = qsrequest("search_sort");
  }
    if ($err_string == "") {
        if ($qry_string != "") {
            $URL="./totals.php?" . $qry_string . $sortstring;
        } else {
            $URL="./totals.php";
        }
        header ("Location: $URL");
        exit;
    }
} else {
$sortstring  = "";
if (qsrequest("sortfield") != "") {
    $sortstring = "&sortfield=" . urlencode(stripslashes(qsrequest("sortfield"))) . "&sortby=" . urlencode(stripslashes(qsrequest("sortby")));
}
$i=0;
while ($i < mysql_num_fields($result)) {
$strkeyword = "";
$iopt = "";
$idata = "";
if ((!isset($_GET["search_fd".$i])) && (!isset($_POST["search_fd".$i]))) {
    $arryitemvalue[$i] = "";
    $arryopt[$i]="";
} else {
    # Check value for advance search
    $idata = qsrequest("search_fd" . $i);
    $iopt = substr($idata, 0, 2); // Get 2 of left keyword
    if (($iopt == "<=") || ($iopt == "=<")){
        $iopt  = "<=";
        $strkeyword = substr($idata, 2);
    }elseif (($iopt == ">=") || ($iopt == "=>")){
        $iopt = ">=";
        $strkeyword = substr($idata, 2);
    }elseif ($iopt == "==" ){
        $iopt = "==";
        $strkeyword = substr($idata, 2);
    }elseif ($iopt == "<>"){
        $strkeyword = substr($idata, 2);
    } else {
        $startstrdata = substr(qsrequest("search_fd" . $i),0,1) ;
        $endstrdata = $idata[strlen(qsrequest("search_fd" . $i)) - 1];
        if (($startstrdata != "%" ) && ($endstrdata != "%")){
            if (($startstrdata == "<") || ($startstrdata == ">") || ($startstrdata == "=")) {
                if ($startstrdata == "<") {
                    $strkeyword = str_replace("<","", qsrequest("search_fd" . $i)) ;
                    $iopt = "<";
                }elseif($startstrdata == ">")  {
                    $strkeyword = str_replace(">","", qsrequest("search_fd" . $i)) ;
                    $iopt = ">";
                } else {
                    $strkeyword = str_replace("=","", qsrequest("search_fd" . $i)) ;
                    $iopt = "=";
                }
            }else {
                $arryitemvalue[$i] = qsrequest("search_fd". $i);
                $strkeyword = qsrequest("search_fd". $i);
            }
        }else {
            if (($startstrdata == "%" ) && ($endstrdata == "%")) {  # Contain Case
                $startstrdata = str_replace("%","", qsrequest("search_fd" . $i)) ;
                $strkeyword  = substr(qsrequest("search_fd" . $i),1, (strlen(qsrequest("search_fd" . $i))-2));
                $iopt = "^^" ;
            }elseif (($startstrdata != "%" ) && ($endstrdata == "%")) {  # Start With Case xx*
                $strkeyword  = substr(qsrequest("search_fd" . $i),0, (strlen(qsrequest("search_fd" . $i))-1));
                $iopt = "^*";
            }elseif (($startstrdata == "%" ) && ($endstrdata != "%")) { # End With Case *xx
                $strkeyword  = substr(qsrequest("search_fd" . $i),1, (strlen(qsrequest("search_fd" . $i))));
                $iopt = "*^";
            }
        }// end eheck one charator
   }//end of check 2 first character
   $arryitemvalue[$i] = $strkeyword;
   $arryopt[$i] = $iopt;
}
$i += 1;
}// end while
if ($result > 0) {mysql_free_result($result);}
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="search.css">
</head>
<body>
<Center>
 
 
<form name="QS_Search_Form" method="post" action="./totals_search.php">
 
<table border="0" cellpadding="4" cellspacing="1" bgcolor="#D4D4D4">
 
<?php
if ($sortstring != "") {
  print "<input name=\"search_sort\" type=\"hidden\" value=\"".$sortstring."\">";
}
?>
 
<tr>
<td colspan="2" class="ThRows">Search</td>
</tr>
<?php
$css_class = "\"odd\"";
if ($err_string != "") {
    print "<tr>";
    print "<td class=\"th2\"><strong>Error:</strong></td>";
    print "<td class=" . $css_class . " align=Default>" . $err_string . "</td>";
    print "</tr>";
}
?>
 
<tr>
<td class="row1">MASTER ID</td>
<?php
if ((!isset($_GET["search_fd0"])) && (!isset($_POST["search_fd0"]))) {
    $itemvalue = "";
} else {
    $itemvalue = qsrequest("search_fd0");
}
 
    $cellvalue = "<select name=\"search_optfd0\"><option value=\"^^\"" . qscheckselected("^^",$arryopt[0],"selected") . ">contains</option><option value=\"^*\"" . qscheckselected("^*",$arryopt[0],"selected") . ">starts with</option><option value=\"*^\"" . qscheckselected("*^",$arryopt[0],"selected") . ">ends with</option><option value=\"==\"" . qscheckselected("==",$arryopt[0],"selected") . ">is equal to</option><option value=\"<>\"" . qscheckselected("<>",$arryopt[0],"selected") . ">is not equal to</option><option value=\"<\"" . qscheckselected("<",$arryopt[0],"selected") . ">is less than</option><option value=\"<=\"" . qscheckselected("<=",$arryopt[0],"selected") . ">is less than or equal to</option><option value=\">\"" . qscheckselected(">",$arryopt[0],"selected") . ">is greater than</option><option value=\">=\"" . qscheckselected(">=",$arryopt[0],"selected") . ">is greater than or equal to</option></select><input type=\"text\" name=\"search_fd0\" value=\"" . qsreplace_html_quote(stripslashes($arryitemvalue[0])) . "\">" . "<input type=\"hidden\" name=\"multisearch_fd0\" value=\"\">";
    if ($cellvalue == "") {
        $cellvalue = "&nbsp;";
    }
    print "<td class=" . $css_class . "  align=Default >" . $cellvalue . "</td>";
?>
</tr>
 
<tr>
<td class="row1">DIVISION</td>
<?php
if ((!isset($_GET["search_fd1"])) && (!isset($_POST["search_fd1"]))) {
    $itemvalue = "";
} else {
    $itemvalue = qsrequest("search_fd1");
}
 
    $cellvalue = "<select name=\"search_optfd1\"><option value=\"^^\"" . qscheckselected("^^",$arryopt[1],"selected") . ">contains</option><option value=\"^*\"" . qscheckselected("^*",$arryopt[1],"selected") . ">starts with</option><option value=\"*^\"" . qscheckselected("*^",$arryopt[1],"selected") . ">ends with</option><option value=\"==\"" . qscheckselected("==",$arryopt[1],"selected") . ">is equal to</option><option value=\"<>\"" . qscheckselected("<>",$arryopt[1],"selected") . ">is not equal to</option><option value=\"<\"" . qscheckselected("<",$arryopt[1],"selected") . ">is less than</option><option value=\"<=\"" . qscheckselected("<=",$arryopt[1],"selected") . ">is less than or equal to</option><option value=\">\"" . qscheckselected(">",$arryopt[1],"selected") . ">is greater than</option><option value=\">=\"" . qscheckselected(">=",$arryopt[1],"selected") . ">is greater than or equal to</option></select><input type=\"text\" name=\"search_fd1\" value=\"" . qsreplace_html_quote(stripslashes($arryitemvalue[1])) . "\">" . "<input type=\"hidden\" name=\"multisearch_fd1\" value=\"\">";
    if ($cellvalue == "") {
        $cellvalue = "&nbsp;";
    }
    print "<td class=" . $css_class . "  align=Default >" . $cellvalue . "</td>";
?>
</tr>
 
<tr>
<td class="row1">LOCATION</td>
<?php
if ((!isset($_GET["search_fd2"])) && (!isset($_POST["search_fd2"]))) {
    $itemvalue = "";
} else {
    $itemvalue = qsrequest("search_fd2");
}
 
    $cellvalue = "<select name=\"search_optfd2\"><option value=\"^^\"" . qscheckselected("^^",$arryopt[2],"selected") . ">contains</option><option value=\"^*\"" . qscheckselected("^*",$arryopt[2],"selected") . ">starts with</option><option value=\"*^\"" . qscheckselected("*^",$arryopt[2],"selected") . ">ends with</option><option value=\"==\"" . qscheckselected("==",$arryopt[2],"selected") . ">is equal to</option><option value=\"<>\"" . qscheckselected("<>",$arryopt[2],"selected") . ">is not equal to</option><option value=\"<\"" . qscheckselected("<",$arryopt[2],"selected") . ">is less than</option><option value=\"<=\"" . qscheckselected("<=",$arryopt[2],"selected") . ">is less than or equal to</option><option value=\">\"" . qscheckselected(">",$arryopt[2],"selected") . ">is greater than</option><option value=\">=\"" . qscheckselected(">=",$arryopt[2],"selected") . ">is greater than or equal to</option></select><input type=\"text\" name=\"search_fd2\" value=\"" . qsreplace_html_quote(stripslashes($arryitemvalue[2])) . "\">" . "<input type=\"hidden\" name=\"multisearch_fd2\" value=\"\">";
    if ($cellvalue == "") {
        $cellvalue = "&nbsp;";
    }
    print "<td class=" . $css_class . "  align=Default >" . $cellvalue . "</td>";
?>
</tr>
 
<tr>
<td class="row1">QUOTA ID</td>
<?php
if ((!isset($_GET["search_fd3"])) && (!isset($_POST["search_fd3"]))) {
    $itemvalue = "";
} else {
    $itemvalue = qsrequest("search_fd3");
}
 
    $cellvalue = "<select name=\"search_optfd3\"><option value=\"^^\"" . qscheckselected("^^",$arryopt[3],"selected") . ">contains</option><option value=\"^*\"" . qscheckselected("^*",$arryopt[3],"selected") . ">starts with</option><option value=\"*^\"" . qscheckselected("*^",$arryopt[3],"selected") . ">ends with</option><option value=\"==\"" . qscheckselected("==",$arryopt[3],"selected") . ">is equal to</option><option value=\"<>\"" . qscheckselected("<>",$arryopt[3],"selected") . ">is not equal to</option><option value=\"<\"" . qscheckselected("<",$arryopt[3],"selected") . ">is less than</option><option value=\"<=\"" . qscheckselected("<=",$arryopt[3],"selected") . ">is less than or equal to</option><option value=\">\"" . qscheckselected(">",$arryopt[3],"selected") . ">is greater than</option><option value=\">=\"" . qscheckselected(">=",$arryopt[3],"selected") . ">is greater than or equal to</option></select><input type=\"text\" name=\"search_fd3\" value=\"" . qsreplace_html_quote(stripslashes($arryitemvalue[3])) . "\">" . "<input type=\"hidden\" name=\"multisearch_fd3\" value=\"\">";
    if ($cellvalue == "") {
        $cellvalue = "&nbsp;";
    }
    print "<td class=" . $css_class . "  align=Default >" . $cellvalue . "</td>";
?>
</tr>
 
<tr>
<td class="row1">QUOTA</td>
<?php
if ((!isset($_GET["search_fd4"])) && (!isset($_POST["search_fd4"]))) {
    $itemvalue = "";
} else {
    $itemvalue = qsrequest("search_fd4");
}
 
    $cellvalue = "<select name=\"search_optfd4\"><option value=\"^^\"" . qscheckselected("^^",$arryopt[4],"selected") . ">contains</option><option value=\"^*\"" . qscheckselected("^*",$arryopt[4],"selected") . ">starts with</option><option value=\"*^\"" . qscheckselected("*^",$arryopt[4],"selected") . ">ends with</option><option value=\"==\"" . qscheckselected("==",$arryopt[4],"selected") . ">is equal to</option><option value=\"<>\"" . qscheckselected("<>",$arryopt[4],"selected") . ">is not equal to</option><option value=\"<\"" . qscheckselected("<",$arryopt[4],"selected") . ">is less than</option><option value=\"<=\"" . qscheckselected("<=",$arryopt[4],"selected") . ">is less than or equal to</option><option value=\">\"" . qscheckselected(">",$arryopt[4],"selected") . ">is greater than</option><option value=\">=\"" . qscheckselected(">=",$arryopt[4],"selected") . ">is greater than or equal to</option></select><input type=\"text\" name=\"search_fd4\" value=\"" . qsreplace_html_quote(stripslashes($arryitemvalue[4])) . "\">" . "<input type=\"hidden\" name=\"multisearch_fd4\" value=\"\">";
    if ($cellvalue == "") {
        $cellvalue = "&nbsp;";
    }
    print "<td class=" . $css_class . "  align=Default >" . $cellvalue . "</td>";
?>
</tr>
 
<tr>
<td colspan="2" class="rows" align=Center>
<input type="button" name="QS_Back" value="Back" OnClick="history.back()">&nbsp;&nbsp;
<input type="submit" name="QS_Submit" value="Run">&nbsp;&nbsp;
<input type="button" name="QS_Clear" value="Clear" OnClick="location='totals_search.php'">
</td>
</tr>
</table><br>
</form>
 
<?php
@mysql_close($link);
?>
 
</center>
 
</body>
</html>

Select allOpen in new window

<?php
session_start();
require ('conn.php');
require ('func.php');
$err_string = "";
$quotechar = "`";
$quotedate = "'";
$sql = "";
$sql_ext = "";
$cellvalue = "";
$istrdata = "";
$sortstring = "";
$fields = array();
$fields[0] = "master.id";
$fields[1] = "master.division";
$fields[2] = "quota.id";
$fields[3] = "quota.quota";
$fields[4] = "members.post";
$fields[5] = "members.total";
$fields[6] = "members.percentage";
$fields[7] = "scores.division";
$fields[8] = "scores.a55";
$fields[9] = "managers.division";
$fields[10] = "managers.name";
 
$sql .= " SELECT master.id,
master.division,
master.location,
quota.id,
quota.quota,
members.id,
members.total,
members.percentage,
scores.division,
scores.a55,
managers.division,
managers.name
 
FROM
master   master,
quota   quota,
members   members,
scores   scores,
managers   managers
 
WHERE
master.id = quota.id
AND    master.id = members.id
AND    master.division = scores.division
AND    master.division = managers.division
 
ORDER BY scores.a14 ASC";
 
$searchmode = array();
$stdsearchopt = array();
$sqlgrandtotal = "";
$sqlgrandtotal_ext = "";
$sqlgrandtotal .= "  SELECT Count(*)   FROM      master   master,     quota   quota,     members   members,   scores   scores,     managers   managers  
 
WHERE (     master.id = quota.id     AND    master.id = members.id     AND    master.division = scores.division     AND    master.division = managers.division ) ";
 
 
if (!$result = @mysql_query($sql . " " . $sql_ext . " limit 0,1"))
{
    $err_string .= "<strong>Error:</strong>while connecting to database<br>" .
        mysql_error();
}
if ($err_string != "")
{
    echo "<center><table border=\"0\" cellspacing=\"1\" bgcolor=\"#CCCCCC\" >";
    echo "<tr>";
    echo "<td height=\"80\" align=\"default\" bgcolor=\"#FFFFFF\">";
    echo "<font color=\"#000099\" size=\"2\">";
    echo $err_string;
    echo "</font>";
    echo "</td>";
    echo "</tr>";
    echo "</table></center>";
    exit;
}
$filter_string = "";
$qry_string = "";
$i = 0;
$searchendkey = "";
$searchstartkey = "";
$hidden_tag = "";
while ($i < mysql_num_fields($result))
{
    $meta = mysql_fetch_field($result);
    $field_name = $meta->name;
    $field_table = $meta->table;
    $field_type = $meta->type;
    if (($searchmode[$i]) == 0)
    { # 0 = Std, 1 = Advance
        if (($stdsearchopt[$i]) == 0)
        { # 0=Contain , 1 = Equal : for standard mode
            $searchstartkey = "%";
            $searchendkey = "%";
        }
        else
        {
            $searchstartkey = "";
            $searchendkey = "";
        }
    }
    else
    {
 
        $searchstartkey = "";
        $searchendkey = "";
    }
    if ((qsrequest("search_fd" . $i) != "") && (qsrequest("search_fd" . $i) != "*"))
    {
        $idata = qsrequest("search_fd" . $i);
        $idata = str_replace("*", "%", $idata);
        $irealdata = $idata;
        $iopt = substr($idata, 0, 2);
        if (($iopt == "<=") || ($iopt == "=<"))
        {
            $iopt = "<=";
            $irealdata = substr($idata, 2);
        }
        elseif (($iopt == ">=") || ($iopt == "=>"))
        {
            $iopt = ">=";
            $irealdata = substr($idata, 2);
        }
        elseif ($iopt == "==")
        {
            $iopt = "=";
            $irealdata = substr($idata, 2);
        }
        elseif ($iopt == "<>")
        {
            $irealdata = substr($idata, 2);
        }
        else
        {
            $iopt = substr($idata, 0, 1);
            if (($iopt == "<") || ($iopt == ">") || ($iopt == "="))
            {
                $irealdata = substr($idata, 1);
            }
            else
            {
                $iopt = "=";
            }
        }
        if (!strcasecmp($idata, "{current date and time}"))
        {
            $idata = time();
        }
        elseif (!strcasecmp($idata, "{current date}"))
        {
            $idata = time();
        }
        elseif (!strcasecmp($idata, "{current time}"))
        {
            $idata = time();
        }
        if ($meta)
        {
            if ((strtolower($field_type) == "timestamp") || (strtolower($field_type) ==
                "datetime") || (strtolower($field_type) == "smalldatetime") || (strtolower($field_type) ==
                "date") || (strtolower($field_type) == "time") || (strtolower($field_type) ==
                "year"))
            {
                if ((($timestamp = strtotime($irealdata)) !== -1))
                {
                    if (($iopt) == "=")
                    {
                        $conditionstr = " = ";
                        $istrdata = str_replace("=", "", $istrdata);
                    }
                    else
                    {
                        $conditionstr = $iopt;
                        $istrdata = $irealdata;
                        $searchstartkey = "";
                        $searchendkey = "";
                    }
                    if ((qsrequest("multisearch_fd" . $i) != ""))
                    {
                        $multisearch = qsrequest("multisearch_fd" . $i);
                        $searcharray = split(",", $multisearch);
                        if ($qry_string == "")
                        {
                            $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                            $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                            $filter_string = "(" . $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey .
                                $irealdata . $searchendkey . $quotedate;
                            $j = 0;
                            for ($j = 0; $j < count($searcharray); $j++)
                            {
                                $searchindex = $searcharray[$j];
                                $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " " . $quotedate .
                                    $searchstartkey . $irealdata . $searchendkey . $quotedate;
                            }
                            $filter_string .= ")";
                        }
                        else
                        {
                            $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                            $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                            $filter_string .= " AND (" . $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey .
                                $irealdata . $searchendkey . $quotedate;
                            $j = 0;
                            for ($j = 0; $j < count($searcharray); $j++)
                            {
                                $searchindex = $searcharray[$j];
                                $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " " . $quotedate .
                                    $searchstartkey . $irealdata . $searchendkey . $quotedate;
                            }
                            $filter_string .= ")";
                        }
                    }
                    else
                    {
                        if ($qry_string == "")
                        {
                            $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                            $filter_string = $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey .
                                $irealdata . $searchendkey . $quotedate;
                        }
                        else
                        {
                            $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                            $filter_string .= " AND " . $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey .
                                $irealdata . $searchendkey . $quotedate;
                        }
                    }
                }
                else
                {
                    $err_string .= "<strong>Error:</strong>while searching.<strong>" . $field_name .
                        "</strong>.<br>";
                    $err_string .= "Description: Invalid DateTime.<br>";
                }
            }
            elseif (($meta->numeric) == 1)
            {
                $irealdata = str_replace("%", "", $irealdata);
                if (is_numeric($irealdata))
                {
                    if ((qsrequest("multisearch_fd" . $i) != ""))
                    {
                        $multisearch = qsrequest("multisearch_fd" . $i);
                        $searcharray = split(",", $multisearch);
                        if ($qry_string == "")
                        {
                            $qry_string = "search_fd" . $i . "=" . $idata;
                            $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                            $filter_string = "(" . $fields[$i] . " " . $iopt . " " . $irealdata;
                            $j = 0;
                            for ($j = 0; $j < count($searcharray); $j++)
                            {
                                $searchindex = $searcharray[$j];
                                $filter_string .= " OR " . $fields[$searchindex] . " " . $iopt . " " . $irealdata;
                            }
                            $filter_string .= ")";
                        }
                        else
                        {
                            $qry_string .= "&search_fd" . $i . "=" . $idata;
                            $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                            $filter_string .= " AND (" . $fields[$i] . " " . $iopt . " " . $irealdata;
                            $j = 0;
                            for ($j = 0; $j < count($searcharray); $j++)
                            {
                                $searchindex = $searcharray[$j];
                                $filter_string .= " OR " . $fields[$searchindex] . " " . $iopt . " " . $irealdata;
                            }
                            $filter_string .= ")";
                        }
                    }
                    else
                    {
                        if ($qry_string == "")
                        {
                            $qry_string = "search_fd" . $i . "=" . $idata;
                            $filter_string = $fields[$i] . " " . $iopt . " " . $irealdata;
                        }
                        else
                        {
                            $qry_string .= "&search_fd" . $i . "=" . $idata;
                            $filter_string .= " AND " . $fields[$i] . " " . $iopt . " " . $irealdata;
                        }
                    }
                }
                else
                {
                    $err_string .= "<strong>Error:</strong>while searching.<strong>" . $field_name .
                        "</strong>.<br>";
                    $err_string .= "Description: Type mismatch.<br>";
 
                }
            }
            elseif ((strtolower($field_type) == "blob") || (strtolower($field_type) ==
                "mediumblob") || (strtolower($field_type) == "longblob"))
            {
                if ($qry_string == "")
                {
                    $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                    $filter_string = $fields[$i] . " Like '" . ereg_replace("'", "''", stripslashes
                        ($irealdata)) . "'";
                }
                else
                {
                    $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                    $filter_string .= " AND " . $fields[$i] . " Like '" . ereg_replace("'", "''",
                        stripslashes($irealdata)) . "'";
                }
            }
            elseif ((strtolower($field_type) == "varchar") || (strtolower($field_type) ==
                "char") || (strtolower($field_type) == "text") || (strtolower($field_type) ==
                "tinytext") || (strtolower($field_type) == "mediumtext") || (strtolower($field_type) ==
                "string") || (strtolower($field_type) == "longtext") || (strtolower($field_type) ==
                "nvarchar") || (strtolower($field_type) == "nchar") || (strtolower($field_type) ==
                "ntext"))
            {
                if (($iopt) == "=")
                {
                    $conditionstr = " Like ";
                    $istrdata = str_replace("=", "", $istrdata);
                }
                else
                {
                    $conditionstr = $iopt;
                    $istrdata = $irealdata;
                    $searchstartkey = "";
                    $searchendkey = "";
                }
                if ((qsrequest("multisearch_fd" . $i) != ""))
                {
                    $multisearch = qsrequest("multisearch_fd" . $i);
                    $searcharray = split(",", $multisearch);
                    if ($qry_string == "")
                    {
                        $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                        $filter_string = "(" . $fields[$i] . $conditionstr . " '" . $searchstartkey .
                            ereg_replace("'", "''", stripslashes($irealdata)) . $searchendkey . "'";
                        $j = 0;
                        for ($j = 0; $j < count($searcharray); $j++)
                        {
                            $searchindex = $searcharray[$j];
                            $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " '" . $searchstartkey .
                                ereg_replace("'", "''", stripslashes($irealdata)) . $searchendkey . "'";
                        }
                        $filter_string .= ")";
                    }
                    else
                    {
                        $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                        $filter_string .= " AND (" . $fields[$i] . $conditionstr . " '" . $searchstartkey .
                            ereg_replace("'", "''", stripslashes($irealdata)) . $searchendkey . "'";
                        $j = 0;
                        for ($j = 0; $j < count($searcharray); $j++)
                        {
                            $searchindex = $searcharray[$j];
                            $filter_string .= " OR " . $fields[$searchindex] . $conditionstr . " '" . $searchstartkey .
                                ereg_replace("'", "''", stripslashes($irealdata)) . $searchendkey . "'";
                        }
                        $filter_string .= ")";
                    }
                }
                else
                {
                    if ($qry_string == "")
                    {
                        $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string = $fields[$i] . $conditionstr . " '" . $searchstartkey .
                            ereg_replace("'", "''", stripslashes($irealdata)) . $searchendkey . "'";
 
 
 
                    }
                    else
                    {
                        $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string .= " AND " . $fields[$i] . $conditionstr . " '" . $searchstartkey .
                            ereg_replace("'", "''", stripslashes($irealdata)) . $searchendkey . "'";
                    }
                }
            }
            else
            {
                if ((qsrequest("multisearch_fd" . $i) != ""))
                {
                    $multisearch = qsrequest("multisearch_fd" . $i);
                    $searcharray = split(",", $multisearch);
                    $irealdata = str_replace("%", "", $irealdata);
                    if ($qry_string == "")
                    {
                        $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                        $filter_string = "(" . $fields[$i] . " = '" . ereg_replace("'", "''",
                            stripslashes($irealdata)) . "'";
                        $j = 0;
                        for ($j = 0; $j < count($searcharray); $j++)
                        {
                            $searchindex = $searcharray[$j];
                            $filter_string .= " OR " . $fields[$searchindex] . " = '" . ereg_replace("'",
                                "''", stripslashes($irealdata)) . "'";
                        }
                        $filter_string .= ")";
                    }
                    else
                    {
                        $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $qry_string .= "&multisearch_fd" . $i . "=" . qsrequest("multisearch_fd" . $i);
                        $filter_string .= " AND (" . $fields[$i] . " = '" . ereg_replace("'", "''",
                            stripslashes($irealdata)) . "'";
                        $j = 0;
                        for ($j = 0; $j < count($searcharray); $j++)
                        {
                            $searchindex = $searcharray[$j];
                            $filter_string .= " OR " . $fields[$searchindex] . " = '" . ereg_replace("'",
                                "''", stripslashes($irealdata)) . "'";
                        }
                        $filter_string .= ")";
                    }
                }
                else
                {
                    if ($qry_string == "")
                    {
                        $qry_string = "search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string = $fields[$i] . " like '" . ereg_replace("'", "''", stripslashes
                            ($irealdata)) . "'";
                    }
                    else
                    {
                        $qry_string .= "&search_fd" . $i . "=" . urlencode(stripslashes($idata));
                        $filter_string .= " AND " . $fields[$i] . " like '" . ereg_replace("'", "''",
                            stripslashes($irealdata)) . "'";
                    }
                }
            }
        }
    }
    if (qsrequest("search_fd_" . $i) != "")
    {
        $idata = qsrequest("search_fd_" . $i);
        $idata = str_replace("*", "%", $idata);
        $irealdata = $idata;
        $iopt = substr($idata, 0, 2);
        if (($iopt == "<=") || ($iopt == "=<"))
        {
            $iopt = "<=";
            $irealdata = substr($idata, 2);
        }
        elseif (($iopt == ">=") || ($iopt == "=>"))
        {
            $iopt = ">=";
            $irealdata = substr($idata, 2);
        }
        elseif ($iopt == "==")
        {
            $iopt = "=";
            $irealdata = substr($idata, 2);
        }
        elseif ($iopt == "<>")
        {
            $irealdata = substr($idata, 2);
        }
        else
        {
            $iopt = substr($idata, 0, 1);
            if (($iopt == "<") || ($iopt == ">") || ($iopt == "="))
            {
                $irealdata = substr($idata, 1);
            }
            else
            {
                $iopt = "=";
            }
        }
        if ($meta)
        {
            if ((strtolower($field_type) == "timestamp") || (strtolower($field_type) ==
                "datetime") || (strtolower($field_type) == "smalldatetime") || (strtolower($field_type) ==
                "date") || (strtolower($field_type) == "time") || (strtolower($field_type) ==
                "year"))
            {
                if ((($timestamp = strtotime($irealdata)) !== -1))
                {
                    if (($iopt) == "=")
                    {
                        $conditionstr = " = ";
                        $istrdata = str_replace("=", "", $istrdata);
                    }
                    else
                    {
                        $conditionstr = $iopt;
                        $istrdata = $irealdata;
                        $searchstartkey = "";
                        $searchendkey = "";
                    }
                }
                if ($qry_string == "")
                {
                    $qry_string = "search_fd_" . $i . "=" . $iopt . urlencode(stripslashes($irealdata));
                    $filter_string = $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey .
                        $irealdata . $searchendkey . $quotedate;
                }
                else
                {
                    $qry_string .= "&search_fd_" . $i . "=" . $iopt . urlencode(stripslashes($irealdata));
                    $filter_string .= " AND " . $fields[$i] . $conditionstr . " " . $quotedate . $searchstartkey .
                        $irealdata . $searchendkey . $quotedate;
                }
            }
            elseif ((strtolower($field_type) == "integer") || (strtolower($field_type) ==
                "int") || (strtolower($field_type) == "smallint") || (strtolower($field_type) ==
                "tinyint") || (strtolower($field_type) == "longint") || (strtolower($field_type) ==
                "counter") || (strtolower($field_type) == "autoincrement") || (strtolower($field_type) ==
                "float") || (strtolower($field_type) == "real") || (strtolower($field_type) ==
                "money") || (strtolower($field_type) == "smallmoney") || (strtolower($field_type) ==
                "short") || (strtolower($field_type) == "long") || (strtolower($field_type) ==
                "double") || (strtolower($field_type) == "currency") || (strtolower($field_type) ==
                "bit") || (strtolower($field_type) == "decimal") || (strtolower($field_type) ==
                "number") || (strtolower($field_type) == "numeric"))
            {
                $irealdata = str_replace("%", "", $irealdata);
                if (is_numeric($irealdata))
                {
                    if ($qry_string == "")
                    {
                        $qry_string = "search_fd_" . $i . "=" . $iopt . $irealdata;
                        $filter_string = $fields[$i] . " " . $iopt . " " . $irealdata;
                    }
                    else
                    {
                        $qry_string .= "&search_fd_" . $i . "=" . $iopt . $irealdata;
                        $filter_string .= " AND " . $fields[$i] . " " . $iopt . " " . $irealdata;
                    }
                }
                else
                {
                    $err_string .= "<strong>Error:</strong>while searching.<strong>" . $field_name .
                        "</strong>.<br>";
                    $err_string .= "Description: Type mismatch.<br>";
                }
            }
        }
    }
    $i++;
}
if ($result > 0)
{
    mysql_free_result($result);
}
if ($filter_string != "")
{
    $sql .= " and " . $filter_string;
    $sqlgrandtotal .= " and " . $filter_string;
}
if (qsrequest("sortfield") != "")
{
    $sql = $sql . " Order By " . stripslashes(qsrequest("sortfield")) . " " .
        stripslashes(qsrequest("sortby"));
    $sortstring = "&sortfield=" . qsrequest("sortfield") . "&sortby=" . qsrequest("sortby");
}
else
{
    $sql = $sql . " " . $sql_ext;
}
$sqlgrandtotal = $sqlgrandtotal . " " . $sqlgrandtotal_ext;
$result = mysql_query($sql) or die("Invalid query");
$num_rows = mysql_num_rows($result);
$grandtotal_result = mysql_query($sqlgrandtotal) or die("Invalid query");
$grandtotal_num_rows = mysql_num_rows($grandtotal_result);
$current_page = 1;
$page_count = 1;
$page_size = 99999;
$page_number_style1 = $current_page . "/" . $page_count;
$page_number_style2 = "Page&nbsp;" . $current_page . "&nbsp;of&nbsp;" . $page_count;
?>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="standing.css">
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
</head>
<body>
<center>
 
<?php
if ($num_rows > 0)
{
?>
 
<?php
 
 
        echo "<strong>Standings</strong> ";
        echo "<br />";
 
        echo "<table cellpadding=\'2\' cellspacing=\'0\'>";
 
        echo "<tr>";
        echo "<td class=\"ThRows\" >ORDER</td>";
        echo "<td class=\"ThRows\" >DIVISION</td>";
        echo "<td class=\"ThRows\" >MANAGER</td>";
        echo "<td class=\"ThRows\" >QUOTA</td>";
        echo "<td class=\"ThRows\" >MEMBERS</td>";
        echo "<td class=\"ThRows\" >%QUOTA</td>";
        echo "<td class=\"ThRows\" >SCORE</td>";
        echo "</tr>";
 
 
      session_start();
 
	  
	  $query = "SELECT scores.division, scores.a55, managers.division, managers.name ".
	  
	  "FROM scores, managers ".
	   
	  "WHERE scores.division = managers.division";
	  
      $result = mysql_query($query);
     
      if($result && mysql_num_rows($result) > 0)
      {
            $standings = 1;
            for ($i = 0; $i < mysql_num_rows($result); $i++)
            {
              $resultArray = mysql_fetch_array($result);
	  
         echo ('<tr>');//first row
         if (($rowcount%2) == 0) {
              $css_class = "\"row\"";
          } else {
              $css_class = "\"alt\"";
          }
 
 
            echo ('<td class=' . $css_class . ' align=default >'.$standings.'</td>');
            echo ('<td class=' . $css_class . ' align=default >' . $resultArray[0] . '&nbsp</td>');
            echo ('<td class=' . $css_class . ' align=default >' . $resultArray[3] . '&nbsp</td>');
            echo ('<td class=' . $css_class . ' align=default >' . $_SESSION["sum3"] .'</td>');
            echo ('<td class=' . $css_class . ' align=default >' . $_SESSION["sum4"] .'</td>');
            echo ('<td class=' . $css_class . ' align=default >' . round($_SESSION["avgdsum"],2) . '%</td>');
			echo ('<td class=' . $css_class . ' align=default >' . round($_SESSION["scorestotal"],2) . '</td>');
            echo ('</tr>');
			$standings++;
 
        
		} // end if results
      $i++;
}
 
        echo "</table>";
 
        echo "<br />";
 
session_write_close();
 
?>
 
 
<?php
    }
    else
    {
        if ($filter_string != "")
        {
?>
<Table Border="0" Cellspacing="1" bgcolor="#CCCCCC" >
  <tr>
    <td height="80" align="Default" bgcolor="#FFFFFF">
      <font color="#000099" size="2">
        No record matched your search criteria.
      </font>
    </td>
  </tr>
</Table><br>
 
<?php
        }
        else
        {
?><Table Border="0" Cellspacing="1" bgcolor="#CCCCCC" >
  <tr>
    <td height="80" align="Default" bgcolor="#FFFFFF">
      <font color="#000099" size="2">
        No record found.
      </font>
    </td>
  </tr>
</Table><br>
 
<?php
        }
    }
 
?>
 
<?php
if ($result > 0)
{
    mysql_free_result($result);
}
if ($grandtotal_result > 0)
{
    mysql_free_result($grandtotal_result);
}
@mysql_close($link);
?>
 
</center>
 
</body>
</html>

Select allOpen in new window