$timestart)";
$sep = "";
$qloc = "";
if ($locs) {
$qloc .= " AND (";
foreach ($locs as $key => $value) {
if ($value) {
$value = sqlString($value, 25);
$qloc .= "$sep(location = '$value')";
$sep = " OR ";
}
}
$qloc .= ")";
}
if ($sep)
$q .= $qloc;
$db = "nsftools_misc";
$table = "ls2005sessions";
$dburl = "localhost";
$username = "nsftools_lookup";
$password = "nsftools";
// connect to the server
$con = mysql_connect($dburl, $username, $password);
if (mysql_error())
{
//print "Error Connecting To Server: " . mysql_error() . "
";
print "Database Error. Please try again later.";
exit;
}
// connect to the database
mysql_select_db($db, $con);
if (mysql_error())
{
//print "Error Connecting To Database: " . mysql_error() . "
";
print "Database Error. Please try again later.";
exit;
}
$sep = "";
$arr1 = "";
$arr2 = "";
$count = 0;
$sql = "SELECT * FROM $table WHERE $q";
$out = "";
$result = mysql_query($sql);
if (mysql_error())
{
//print "SQL Error: " . mysql_error() . "
$sql
";
print "Lookup Error. Please use different search terms.";
exit;
} else {
//print "$sql
"; $num_rows = mysql_num_rows($result); $out .= "$num_rows sessions matched your search.
\n"; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $out .= "
" . $row["title"] . "
\n";
$out .= "" . $row["day"] . ", " . $row["timestr"] . " ";
$out .= "(link)
\n";
$out .= $row["room"] . " (" . $row["location"] . ")
\n"; $out .= "SPEAKERS: " . $row["speakers"] . "
\n"; $out .= $row["description"] . "
\n\n"; } } print $out; mysql_close($con); ?>