Miscellany

<?php$action = $_REQUEST['action'];$order_by = $_GET['order_by'];if (empty($order_by)) {$order_by='last_name';};$color1 = "#F5F9FE";$color2 = "#ECF1FD";if ($action=="Search") {		$value[0] = $_POST['search_first_name'];	$value[1] = $_POST['search_last_name'];	$value[2] = $_POST['search_account_name'];	$value[3] = $_POST['search_email'];	$title[0] = 'search_first_name';	$title[1] = 'search_last_name';	$title[2] = 'search_account_name';	$title[3] = 'search_email';		$and = '';	$search2 = '';	$i=0;	while($i <= 3) {		if(!empty($value[$i]) {			if($i > 0) {$and = 'AND';}			$search[$i] = $and." ".$title[$i]." LIKE '%".$value[$i]."%'";			$search2 = $search2." ".$search[$i];			}		$i++;		}		//if (!empty($search_first_name)) {$search1 = $search."first_name like '%".$search_first_name."%' AND ";}		//if (!empty($search_last_name)) {$search = $search."first_name like '%".$search_last_name."%'";}		$query="SELECT c.*, a.name AS account_name FROM contacts c LEFT JOIN accounts a ON c.account_id=a.id WHERE $search2 ORDER BY $order_by";	}else {	$query="SELECT c.*, a.name AS account_name FROM contacts c LEFT JOIN accounts a ON c.account_id=a.id ORDER BY $order_by";	}