Select Code to Download

  my $data = qq(INSERT INTO temp (url, altavista, yahoo, msn, teoma, g
+oogle, alltheweb, Total) values("$url", "$altavista_results", "$yahoo
+_results", "$msn_results", "$teoma_results", "$google_results", "$all
+theweb_results", "$total") ON DUPLICATE KEY UPDATE altavista = "$alta
+vista_results", yahoo = "$yahoo_results", msn = "$msn_results", teoma
+ = "$teoma_results", google = "$google_results", alltheweb = "$allthe
+web_results", total = "$total");
  my $sth = $dbh->prepare($data);
  $sth->execute() or die $dbh->errstr;

   my $data = qq[SELECT url, altavista, yahoo, msn, teoma, google, all
+theweb, Total FROM temp WHERE id > (SELECT MAX(id) FROM temp) - 10
ORDER BY Total DESC];