Added a special 'between' search that I'll use internally. And also fixed a problem where a MySQL date field can't be compared to an empty string.

1 files changed, 8 insertions, 2 deletions

diff --git a/search.php b/search.php
index d6ab5ed..cbbd290 100644
--- a/search.php
+++ b/search.php
@@ -44,6 +44,7 @@ $database_fields = array(
 // Get all the request parameters into local variables for readability
 $request_params = array(
 	'case_id' => '',
+	'between' => '',
 	'case_years' => '',
 	'case_num' => '',
 	'defendant' => '',
@@ -91,6 +92,11 @@ if ( $case_id ) {
 	$where_parts_and[] = "id = '$case_id'";
 }
 
+if ( $between ) {
+	list($btwn_start, $btwn_end) = explode(':', $between);
+	$where_parts_and[] = "court_case_no BETWEEN '$btwn_start' AND '$btwn_end'";
+}
+
 if ( $case_years && $case_num && $defendant ) {
 	foreach ( $case_years as $case_year ) {
 		$case_year = substr($case_year, -2);
@@ -170,9 +176,9 @@ if ( $disposition ) {
 
 if ( $case_closed ) {
 	if ( $case_closed == 'yes' ) {
-		$where_parts_and[] = " cases.date_closed IS NOT NULL OR cases.date_closed != '' "; 
+		$where_parts_and[] = "cases.date_closed IS NOT NULL"; 
 	} elseif ( $case_closed == 'no' ) {
-		$where_parts_and[] = " cases.date_closed IS NULL OR cases.date_closed = '' "; 
+		$where_parts_and[] = "cases.date_closed IS NULL"; 
 	}
 }