Filthy Pedro’s Rock’n’Roll Points Test

Inspired by Filthy Pedro’s Rock’n’Roll Points song, world renowned Rock and Roll boffins and Filthy Pedro himself have designed this test using cutting edge psychological techniques to find out how Rock’n Roll you are.

Do you prefer a cup of tea, crack cocaine or Special K in the morning?

How would you approach a tricky love triangle situation?

Find out how Rock’n’Roll you are…

There are four pages to the quiz. You will then be given your Rock’n Roll Points score and rating. It’s not easy to score well. Good luck…
Rock'n'Roll Points EP

Enter your name and start the test here:

Warning: Rock’n’Roll is not always your friend.

 
See how your friends and family did. View all the recent results.

The Rock’n’Roll statistics:

The average score is currently: “.$average[0].”“;

#Now let’s get the highest scores

$query = “SELECT * FROM `FP_rocktest` ORDER BY `FP_rocktest`.`rocktest_score` DESC”;
$query_result_handle = mysql_query ($query)
or die (‘The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db’);

# make sure that we recieved some data from our query
$num_of_rows = mysql_num_rows ($query_result_handle);

if ($num_of_rows != 0) {echo “

The all time top ten:

“;}

$i=1;
while(($i <= $num_of_rows) AND ($i <= 11)) { if ($i==1 ) { #lets not show the one just enetered } else { $row = mysql_fetch_row ($query_result_handle); echo "“.$row[1].” scored “.$row[2].” Rock’n Roll Points
“;
}

$i++;
}

#Lets get the highest, lowest and average over the last 12 months

$query = “SELECT AVG( rocktest_score ) FROM `FP_rocktest`”;
$query_result_handle = mysql_query ($query)
or die (‘The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db’);

# make sure that we recieved some data from our query
$num_of_rows = mysql_num_rows ($query_result_handle);

$average = mysql_fetch_row ($query_result_handle);

echo “The average score is currently: “.$average[0].”“;

#Now let’s get the lowest scores

$query = “SELECT * FROM `FP_rocktest` ORDER BY `FP_rocktest`.`rocktest_score` ASC”;
$query_result_handle = mysql_query ($query)
or die (‘The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db’);

# make sure that we recieved some data from our query
$num_of_rows = mysql_num_rows ($query_result_handle);

if ($num_of_rows != 0) {echo “

The all time bottom ten:

“;}

$i=1;
while(($i <= $num_of_rows) AND ($i <= 11)) { if ($i==1 ) { #lets not show the one just enetered } else { $row = mysql_fetch_row ($query_result_handle); echo "“.$row[1].” scored “.$row[2].” Rock’n Roll Points
“;
}

$i++;
}

?>

No comments yet.

Leave a Reply