JNG Create Show

Create a New show …

Show Name:
From Date:

To Date:
Closing Date:
Upload Schedule:

 
user_email;

//Execute the query

$query = mysqli_query($connect, “SELECT * FROM jng_shows”);// where Status = ‘Show Created'”);

if(mysqli_num_rows($query) > 0){
echo ‘List of incomplete shows – please finish creation of show!

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;

while($row = mysqli_fetch_assoc($query)) {
$query2 = mysqli_query($connect, “SELECT count(*) as noofrecords FROM jng_classes where Show_ID = ‘”.$row[ID].”‘”);
$row2 = mysqli_fetch_assoc($query2);
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
if($row[Status]==”Show Open”){
echo “

“;
}else{
echo “

“;
}
echo “

“;
if($row[Status]==”Show Open”){
echo “

“;
}else{
echo “

“;
}
echo “

“;
echo “

“;
}
echo ‘

Show Name	From Date	To Date	Show Schedule	Entries Close		No of Classes	Set Status	Status
“.$row[Show_Name].”	“.$row[From_Date].”	“.$row[To_Date].”	Show Schedule	“.$row[Closing_Date].”	Cannot edit classes	Create/View classes	“.$row2[noofrecords].”	CLOSE Show	OPEN for Entries	“.$row[Status].”

‘;
}
echo ‘Return to the admin Home page here‘;
?>