//call the correct script to display reviews based on genre //first we figure out what genre, then run the correct script /* "$QUERY_STRING" is the genre after the question mark in the genre given above */ $QUERY_STRING = $ID; //connect to the database and find the maxnum for the unique ID include("connectdb.php"); $result = mysql_query( "SELECT * FROM $genre WHERE id = $id" ); while ( $row = mysql_fetch_object( $result ) ) { $file_path = "/reviews/images/"; $image = $row["image"]; $bandname = $row["bandname"]; $albumname = $row["albumname"]; // Printing results in HTML print "
| ";
print "Back "; print " | ";
print "Bandname: $row->bandname\n";
print " Albumname: $row->albumname\n"; print " Rating: $row->rating / 5\n"; print " Label: labelurl\">$row->label\n"; print " Official Site: site\" target=_blank>$row->site\n"; print " Buy Album: asid/thegauntlet09-20\" target=_blank>Amazon.com \n"; print " "; print " | ";
print "
| \n";
print "Tracklist "; print "
\n"; print " |
| \n";
print "$row->review \n"; print "Review by: $row->reviewer\n"; print " |