# Show Search Results /** * @author Jeremi Bergman */ * include('C:\user\WWWRoot\topleft.inc'); $msconnect=mssql_connect('ORSERVI','pptaxconnect','oakridge') or die ("Could not connect to database: ".mssql_get_last_message());; $msdb=mssql_select_db("PropertyTax",$msconnect) or die ("Could not connect to table: ".mssql_get_last_message());; # build our where statement if($_POST['THOUSE'] || $_POST['TNSEW'] || $_POST['TSTNAM']) { $where = " WHERE (THOUSE LIKE '%{$_POST['THOUSE']}%' AND TNSEW LIKE '%{$_POST['TNSEW']}%' AND TSTNAM LIKE '%{$_POST['TSTNAM']}%')"; $order = " ORDER BY THOUSE, TNSEW, TSTNAM"; } elseif ($_POST['TRECTN']) { if (!$_POST['TTAXYRa']) { $_POST['TTAXYRa'] = date("Y"); } $where = " WHERE (TRECTN = '{$_POST['TRECTN']}' AND TTAXYR = '{$_POST['TTAXYRa']}')"; $order = " ORDER BY TRECTN"; } elseif($_POST['TNAME1']) { $where = " WHERE (TNAME1 LIKE '%{$_POST['TNAME1']}%')"; $order = " ORDER BY TNAME1, TNAME2"; } elseif($_POST['TMAPN'] || $_POST['TMAPA'] || $_POST['TPARCL'] || $_POST['TGROUP'] || $_POST['TPICOD'] || $_POST['TSPCIN']) { $where = " WHERE (TMAPN LIKE '%{$_POST['TMAPN']}%' AND TMAPA LIKE '%{$_POST['TMAPA']}%' AND TPARCL LIKE '%{$_POST['TPARCL']}%' AND TGROUP LIKE '%{$_POST['TGROUP']}%' AND TPICOD LIKE '%{$_POST['TPICOD']}%' AND TSPCIN LIKE '%{$_POST['TSPCIN']}%')"; $order = " ORDER BY TMAPN,TMAPA,TPARCL"; } else { header("location: TaxSearch.php"); } if ($_POST['TTAXYR'] && !$_POST['TTAXYRa']) { $where .= " AND (TTAXYR = ".date("Y").")"; } $order .= ", TTAXYR DESC"; $query = "SELECT TRECTN,TTAXYR, TNAME1, TSTADR, TTXAMT, TTXBAL, THOUSE, TNSEW, TSTNAM FROM viewTAXINFO_FULL $where $order"; $result = @mssql_query($query); if (@mssql_num_rows($result) == 1) { $row = @mssql_fetch_assoc($result); header("location: ViewTaxNotice.php?TRECTN={$row['TRECTN']}&TTAXYR={$row['TTAXYR']}"); exit; } ?>
| = $row['TNAME1']; ?> | = $row['THOUSE']; ?> = $row['TNSEW']; ?> = $row['TSTNAM']; ?> |
= $row['TTAXYR']; ?> |
$= number_format($row['TTXAMT'],2); ?> | $= number_format($row['TTXBAL'],2); ?> |
| Search yielded no results. | ||||