A table named websites was created with 202 rows using the the top 200 websites (from:https://gtmetrix.com/top1000.html) and google.com and youtube.com. The websites table specification is:
table name: websites columns:
|
The column url contains the complete URL of the each website. The remaining five columns are
gtmetrix.com's five performance measures for websites (all stored as integers):
|
<form name="fred" action="http://.........show_websites.asp" METHOD="POST"> Pick A Performance Measure or the URL: <input type="radio" name="c" value="0"> URL <input type="radio" name="c" value="1"> Page Speed <input type="radio" name="c" value="2"> YSLOW <input type="radio" name="c" value="3"> Load Time <input type="radio" name="c" value="4"> Elements <input type="radio" name="c" value="5"> Size |
The HTML table produced by show_websites.asp should show the following data:
The table should be sorted using the column chosen (one of six) by the HTML page shown above. Additionally use the radio named ad to further describe the sort order. Write only the code for show_websites.asp (NOTE: it is a single pass program, there is NO "main" code). Do NOT use parameters or transaction control. Show no heading row.