####CHECK FOR SESSION INCLUDE "../../secure/session.php"; INCLUDE "../../secure/hitcounter.php"; ####LOG CODE $log_msg = $_SESSION[‘session_playwright_name’].' visited page - shows'; include "../../secure/backuplog.php"; #### #####ADD TO STATS COUNTER ####RAW HITS INCLUDE "../../secure/connectiondetails.php"; ?>
When a user has been granted the rights to perform one of the plays found on StageRights.com the details will be listed here.
##### Search Dates to Organise #SORT YEAR $SQL = "SELECT DISTINCT Year FROM shows ORDER BY Year"; $result = mysql_query($SQL); while ($db_field = mysql_fetch_assoc($result)){ $GettheYear = $db_field['Year']; #SORT MONTH $SQLA = "SELECT DISTINCT Month FROM shows WHERE Year = '$GettheYear' ORDER BY Month "; $resultA = mysql_query($SQLA); while ($db_field = mysql_fetch_assoc($resultA)){ $GettheMonth = $db_field['Month']; #SORT DAY $SQLB = "SELECT * FROM shows WHERE Year = '$GettheYear' AND Month = '$GettheMonth' ORDER BY Day "; $resultB = mysql_query($SQLB); while ($db_field = mysql_fetch_assoc($resultB)){ $ListingDay = $db_field['Day']; $ListingMonth = $db_field['Month']; $ListingYear = $db_field['Year']; $ListingTime = $db_field['Time']; $ListingTitle = $db_field['Title']; $ListingPlaywright = $db_field['Playwright']; $ListingVenue = $db_field['Venue']; $ListingCompany = $db_field['Company']; $ListingTickets = $db_field['Ticket Prices']; $Listingshowunq = $db_field['Script_unq'] ; $Listingwriterunq = $db_field['playwright_unq']; ####LISTING echo '