Scheduled Auditions Backup

[insert_php]
$parms = “yes”;
if($_GET[“prod”] == “”) $parms = “no”;
$prod = “‘” . $_GET[‘prod’] . “‘”;
$person = $_GET[‘person’] ;

if ($person <> “”) {
$pers = str_replace(“~”,” “,$person);
$pers = str_replace(“\'”,”‘”,$pers);
echo “ Performance Schedule for ” . “” . $pers . ““;

};

$showparm = ““];

date_default_timezone_set(“America/New_York”);
echo “

“;
echo “

“;
echo “

“;

$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);

if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}

$today = date(“Y-m-d”);
$date = strtotime(“+5 day”);
$wkend = date(“Y-m-d”, $date);

$sql = “SELECT AuditionInfo.LastDate, AuditionInfo.Production, AuditionInfo.AuditionDates, Performances.Company, Performances.ShowName from `AuditionInfo`
INNER JOIN Performances
ON AuditionInfo.Production = Performances.Production
where LastDate >= ‘$today’
order by ShowName, Company”;

$result = $mysqli->query($sql);
$olddate = “old”;

if ($result->num_rows > 0) {
// output data of each row

while($row = $result->fetch_assoc()) {

$showfix = str_replace(” “,”~”,$row[“ShowName”]);
$showfix = str_replace(“&”,”^”,$showfix);
$showparm = ““;
$persparm = ““;

echo “

“;

}
} else {
echo “0 results”;
}
echo “

Show Company Audition Dates
” . $showparm . $row[“ShowName”] . ““. “ ” . $row[“Company”] . “ ” . $row[“AuditionDates”] . “

“;
$mysqli->close();

[/insert_php]