home searchadd";
echo "";
if(!isset($_POST["search_by"]) || (intval($_POST["search_by"])==3 && !isset($_POST["string"])) || (intval($_POST["search_by"])==4 && !isset($_POST["string"]))) die ("Error! Missing parameters.");
define( '_ALEX_PROJECT2_EXEC', 1 );
require_once("config.php");
$conn = mysql_connect(DB_HOST . ":" . DB_PORT, DB_USER, DB_PASS);
if (!$conn) die("Error! Cannot connect to MySQL Database.");
mysql_select_db(DB_NAME);
$sql = "SELECT * FROM events2";
// soon (within a week)
if(intval($_POST["search_by"])==2) $sql .= " WHERE time<" . (time()+7*24*3600) . " AND ";
// search by zip
else if(intval($_POST["search_by"])==3) $sql .= " WHERE zip=" . intval($_POST["string"]) . " AND ";
// search by title
else if(intval($_POST["search_by"])==4) $sql .= " WHERE title LIKE '" . str_replace("'","''",$_POST["string"]) . "' AND ";
// previous events
else if(intval($_POST["search_by"])==5) $sql .= " WHERE time<" . time();
// if not showing all, show only future events
if(intval($_POST["search_by"])!=5 && intval($_POST["search_by"])!=1) $sql .= " time>" . time();
$sql .= " ORDER BY time ASC LIMIT 10;";
$result = mysql_query($sql) OR die(mysql_error());
if (mysql_num_rows($result)===0){
echo "No events found";
} else {
date_default_timezone_set("America/New_York");
echo "