[insert_php]
$parms = “yes”;
if($_GET[“parm1”] == “”) $parms = “no”;
$parm1 = “‘” . $_GET[‘parm1’] . “‘”;
$perf = $_GET[‘parm1’] ;
$show = $_GET[‘show’] ;
if ($show <> “”) {
$showfix = str_replace(“~”,” “,$show);
$showfix = str_replace(“^”,”&”,$showfix);
$showfix = str_replace(“@”,”‘”,$showfix);
$showfix = str_replace(“\\”,””,$showfix);
echo “” . “” . $showfix . ““;
}
$perfparm = “Back“;
$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);
if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}
$sql = “SELECT Production, Type, Role, Name from `Cast`
where Production = $parm1 and Type <> ‘Production’ and Role <> ” order by Type, ID”;
$result = $mysqli->query($sql);
$norole = 1;
if ($result->num_rows > 0) {
$norole = 0;
}
$mysqli->close();
$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);
if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}
$sql = “SELECT Production, Type, Role, Name from `Cast`
where Production = $parm1 and Type <> ‘Production’ order by Type, ID”;
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
// output data of each row
echo “
Cast
“;
echo “
“;
echo “
Role | Name |
Name | |
” . $row[“Role”] . “” . “ | ” . $persparm . $row[“Name”] . “ |
” . $persparm . $row[“Name”] . “ |
“;
$mysqli->close();
//PRODUCTION TEAM ****************************************************************
$mysqli = new mysqli(‘localhost’, ‘lictc_user’, ‘lictc’, ‘lictc’);
if ($mysqli->connect_error) {
die(‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘
. $mysqli->connect_error);
}
$sql = “SELECT Production, Type, Role, Name from `Cast`
where Production = $parm1 and Type = ‘Production’ order by Type, ID”;
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
// output data of each row
echo “
Production Team
“;
echo “
Role | Name |
” . $row[“Role”] . “” . “ | ” . $persparm . $row[“Name”] . “ |
“;
$mysqli->close();
[/insert_php]