Search Opera Collection

-1){} else { $SelectedValue = str_replace(" ", ", ", $SelectedValue); } if(!$submit) { echo "
"; echo "
"; echo "\n"; echo "\n "; echo "\n "; echo ""; echo "
Search For:Search Tips:

Please enter the last name first if your criteria are the following: Composer, Soprano, Mezzo_Soprano, Tenor, Baritone, Bass, or Conductor.

If you want to display all the data select the criteria to sort the table and submit.

Select Preferred Criteria:
"; echo "
"; echo "
"; print "Home"; } else { $link=mysql_connect('localhost:6033','adrsuarez','nirvana'); mysql_select_db('adrsuarez'); if(!$link) { print "Can't connect to localhost. The error is
"; print mysql_connect_error(); print"
"; } $error=mysql_error(); if ($error) { print "mySQL error: $error
\n" ; } $query="SELECT * FROM opera1_cd WHERE LOWER($Field) LIKE '$SelectedValue%' ORDER BY $Field ASC"; $result=mysql_query($query); $error=mysql_error(); if($error) { print "query $query lead to error $error"; } print '
'; print ''; $Data = ''; $Data = $Data.''; $HasResults = 0; While($count=mysql_fetch_array($result)) { $HasResults = $HasResults + 1; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; $Data = $Data.''; } if($HasResults == 0) { print ''; } else { print $Data; } print '
COMPOSERTITLESOPRANOMEZZO-SOPRANOTENORBARITONEBASSCONDUCTORORCHESTRAPUBLISHERCDS NUMBER
 '.$count['Composer'].' '.$count['Title'].' '.$count['Soprano'].' '.$count['Mezzo_Soprano'].' '.$count['Tenor'].' '.$count['Baritone'].' '.$count['Bass'].' '.$count['Conductor'].' '.$count['Orchestra'].' '.$count['Publisher'].' '.$count['CDS Number'].'
Sorry, no match found.
'; print '
'; print "Back"; } ?>

Valid XHTML 1.0!