Search

Searching for scripts on StageRights is easy.

Simply enter a search term in one of the search boxes on the right hand side of the screen.

 

More ways of searching for scripts, such as category, genre and number of roles will be added to the search function soon.

';} if($searchcontent=='1'){echo '

Searching in Titles

'; #####SEE HOW MANY PAGES TO SPLIT RESULTS INTO $FINDIT12 = "SELECT * FROM Scripts_Confirmed WHERE Title LIKE '%$searchterm%' AND Confirmed = 'Y'"; $result102 = mysql_query($FINDIT12); $rnumRows = mysql_num_rows($result102); if($rnumRows == '0'){}else{$numderofpages=$rnumRows/10;} $numderofpages = ceil($numderofpages); if ($numderofpages >= 2){ $searchpagenumber = $HTTP_POST_VARS['pagemenu']; if ($searchpagenumber==''){$searchpagenumber='1';} echo '

Go to results page '; $i = 1; while ($i <= $numderofpages){ echo ' '.$i.'';$i++; } echo '

'; } #CHECK FOR MATCHES $begin = ($searchpagenumber - 1)*10; if ($begin < 0){$begin = 0;} $FINDIT12 = "SELECT * FROM Scripts_Confirmed WHERE Title LIKE '%$searchterm%' AND Confirmed = 'Y' LIMIT $begin, 10"; $result102 = mysql_query($FINDIT12); $numRows = mysql_num_rows($result102); if($numRows == '0'){echo '

Sorry. No results were found.

';}else{ echo '

'.$rnumRows.' result(s) were found.

';} while ($db_field = mysql_fetch_assoc($result102)){ $searchpwname = $db_field['Playwright']; $searchpwunq = $db_field['PlayWright_Unq']; $searchscriptTitle = $db_field['Title']; $searchscriptlink = $db_field['Unq']; $searchscriptcat = $db_field['Cat']; $searchscriptmale = $db_field['M_Roles']; $searchscriptfmale = $db_field['F_Roles']; $searchscriptgenre = $db_field['Genre']; $searchscriptsyn = $db_field['Synopsis']; $searchscriptsyn = substr($searchscriptsyn,0,200); $searchscriptsyn = $searchscriptsyn . '...'; #Display Results echo '

'; } } if($searchcontent=='2'){echo '

Searching in Keywords

'; #####SEE HOW MANY PAGES TO SPLIT RESULTS INTO $FINDIT12 = "SELECT * FROM Scripts_Confirmed WHERE Title LIKE '%$searchterm%' AND Confirmed = 'Y' OR keywords LIKE '%$searchterm%' AND Confirmed = 'Y' OR Synopsis LIKE '%$searchterm%' AND Confirmed = 'Y'"; $result102 = mysql_query($FINDIT12); $rnumRows = mysql_num_rows($result102); if($rnumRows == '0'){}else{$numderofpages=$rnumRows/10;} $numderofpages = ceil($numderofpages); if ($numderofpages >= 2){ $searchpagenumber = $HTTP_POST_VARS['pagemenu']; if ($searchpagenumber==''){$searchpagenumber='1';} echo '

Go to results page '; $i = 1; while ($i <= $numderofpages){ echo ' '.$i.'';$i++; } echo '

'; } #CHECK FOR MATCHES $begin = ($searchpagenumber - 1)*10; if ($begin < 0){$begin = 0;} $FINDIT12 = "SELECT * FROM Scripts_Confirmed WHERE Title LIKE '%$searchterm%' AND Confirmed = 'Y' OR keywords LIKE '%$searchterm%' AND Confirmed = 'Y' OR Synopsis LIKE '%$searchterm%' AND Confirmed = 'Y' LIMIT $begin, 10"; $result102 = mysql_query($FINDIT12); $numRows = mysql_num_rows($result102); if($numRows == '0'){echo '

Sorry. No results were found.

';}else{ echo '

'.$rnumRows.' result(s) were found.

';} while ($db_field = mysql_fetch_assoc($result102)){ $searchpwname = $db_field['Playwright']; $searchpwunq = $db_field['PlayWright_Unq']; $searchscriptTitle = $db_field['Title']; $searchscriptlink = $db_field['Unq']; $searchscriptcat = $db_field['Cat']; $searchscriptmale = $db_field['M_Roles']; $searchscriptfmale = $db_field['F_Roles']; $searchscriptgenre = $db_field['Genre']; $searchscriptsyn = $db_field['Synopsis']; $searchscriptsyn = substr($searchscriptsyn,0,200); $searchscriptsyn = $searchscriptsyn . '...'; #Display Results echo '

'; } } if($searchcontent=='3'){echo '

Searching in Playwrights

'; #####SEE HOW MANY PAGES TO SPLIT RESULTS INTO $FINDIT12 = "SELECT * FROM Playwrights WHERE Name LIKE '%$searchterm%' AND Active = 'Y' AND Type='Playwright' ORDER by Number_of_Scripts "; $result102 = mysql_query($FINDIT12); $rnumRows = mysql_num_rows($result102); if($rnumRows == '0'){}else{$numderofpages=$rnumRows/10;} $numderofpages = ceil($numderofpages); if ($numderofpages >= 2){ $searchpagenumber = $HTTP_POST_VARS['pagemenu']; if ($searchpagenumber==''){$searchpagenumber='1';} echo '

Go to results page '; $i = 1; while ($i <= $numderofpages){ echo ' '.$i.'';$i++; } echo '

'; } #CHECK FOR MATCHES $begin = ($searchpagenumber - 1)*10; if ($begin < 0){$begin = 0;} $FINDIT12 = "SELECT * FROM Playwrights WHERE Name LIKE '%$searchterm%' AND Active = 'Y' AND Type='Playwright' ORDER by Number_of_Scripts LIMIT $begin, 10"; $result102 = mysql_query($FINDIT12); $numRows = mysql_num_rows($result102); if($numRows == '0'){echo '

Sorry. No results were found.

';}else{ echo '

'.$rnumRows.' result(s) were found.

';} while ($db_field = mysql_fetch_assoc($result102)){ $searchpwname = $db_field['Name']; $searchpwunq = $db_field['Unq']; $searchpwscripts = $db_field['Number_of_Scripts']; #Display Results echo '

'; } } ?>

 

Script Search

Search by title

Keyword search

Playwright Search

Search by name

 

Manager|

Profile|

License|

Search|

Shows|

FAQ|

Contact

Log Out

';}else{echo '

• Home|
• About us|
• License|
• Search|
• Members|
• Shows|
• FAQ|
• Contact

';} ?>

© Pyronox Ltd. All right reserved.

• design by:
• Template World