<?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";
	}