/*
function searchresults($val1, $val2, $val3, $val4){
// Search the directory for the search terms provided
	$hostname = "mysql.ece.cmu.edu";
	$database = "travmgmt";
	$username = "textrav";
	$password = "tExt44v";
	
	$news = mysql_pconnect($hostname, $username, $password) or die(mysql_error());
	mysql_select_db($database) or die(mysql_error());
	
	// This block sets up the variables used in the query. Each one adds an AND WHERE style
	//   clause to the query based on what was entered in the forms. 
	// FUTURE: Set it up so people can choose AND / OR / NOT
	if(strcmp($val1,'')==0){ $value1 = ''; }else{ $value1 = " AND `people_firstname` LIKE '%$val1%' ";};
	if(strcmp($val2,'')==0){ $value2 = ''; }else{ $value2 = " AND `people_lastname` LIKE '%$val2%' ";};
	if(strcmp($val3,'')==0){ $value3 = ''; }else{ $value3 = " AND `people_title` LIKE '%$val3%' ";};
	if(strcmp($val4,'')==0){ $value4 = ''; }else{ $value4 = " AND `people_keywords` LIKE '%$val4%'";};
	
	// This takes care of the problem of all records being shown in event of no search terms being entered
	if( strcmp($value1,'')==0 && strcmp($value2,'')==0 && strcmp($value3,'')==0 && strcmp($value4,'')==0  ){
		$limit = 0; 	// If nothing was entered, set the limit to zero;
	}else{
		$limit = 65000;	// otherwise show what was found
	}
	
	// Set the query
	$allQ = mysql_query("SELECT * FROM `dir_people` where people_status LIKE 'active'");
	$sql = "SELECT * FROM `dir_people` WHERE people_status LIKE 'active' $value1 $value2 $value3 $value4 LIMIT $limit";	
	$query = mysql_query($sql) or die(mysql_error());
	
	//Pre-results niceness...
	echo "<blockquote><p><strong>Results Returned: <font color='#990000'>";
	echo mysql_num_rows($query)." of ".mysql_num_rows($allQ)."</font></strong><br>";
	
		// Set up the search terms statement
		$terms = "";
		// parse for that comma trailing problem.
		$comma = "";
		
		if(strcmp($val2,'')!=0 || strcmp($val3,'')!=0 || strcmp($val4,'')!=0){$comma = ', ';}else{$comma = '';}
		if(strcmp($val1,'')!=0){ $terms .= $val1 . $comma;}	// if isset($var) comma = ', '		
		
		if(strcmp($val3,'')!=0 || strcmp($val4,'')!=0){$comma = ', ';}else{$comma = '';}
		if(strcmp($val2,'')!=0){ $terms .= $val2 . $comma;}
		
		if(strcmp($val4,'')!=0){$comma = ', ';}else{$comma = '';}
		if(strcmp($val3,'')!=0){ $terms .= $val3 . $comma;}
		if(strcmp($val4,'')!=0){ $terms .= $val4 . $comma;}
		
	echo "<strong>Based on search terms: <font color='#990000'>$terms</font></strong></p>";
	echo "<table width='700'>";
	$color = '#FFFFFF';	// set alternating bgcolor on the <td>'s
	
	// echo the results		
	while ($row = mysql_fetch_array($query)){
		
		if ($color == '#CCCCCC'){$color='#FFFFFF';}else{$color='#CCCCCC';}
		
		echo "<tr width ='700' bgcolor='$color'>";
		echo "<td width ='200' bgcolor='$color'>";
		echo "<a href='show.php?type=".strtolower($row[people_type])."&id=".$row[people_id]."'>".$row[people_lastname] .", ". $row[people_firstname]."</a>";
		echo "</td>";
		echo "<td width ='500' bgcolor='$color'>";
			echo $row[people_title];
		echo "</td>";
		echo "</tr>";
	}
	
	// Cleanup
	echo "</table>";
	echo "</blockquote>";
	
	// Shut down the connection so Tim Talpas doesn't yell at me. :)
	mysql_close($news);	
}