Untitled

<?php
error_reporting(0);
$con = mysql_connect("localhost","root","") or die('Could not connect: ' . mysql_error());
mysql_select_db("characters", $con);
$s=$_GET['s'];
$top = mysql_query("SELECT ch.`name` AS NAME,SUM(ach.`Points`) AS Points
FROM characters.`character_achievement` ca
INNER JOIN characters.`characters` ch ON ca.`guid`=ch.`guid`
INNER JOIN world.dbc_achievement ach ON ca.`achievement`=ach.`ID`
GROUP BY ch.`guid`
ORDER BY SUM(ach.`Points`) DESC
LIMIT 100;");
$list= mysql_query("SELECT ID,Name FROM world.dbc_achievement WHERE NOT flag&1");
$rank=1;
switch ($s)
{
case "search":
  $achiev=$_POST['achiev'];
  $achievname=mysql_query("SELECT name FROM world.dbc_achievement WHERE id=$achiev");
  $row = mysql_fetch_row($achievname);
  echo $row[0];
  echo "<table id=\"search\">
  <tr>
  <th>Name</th>
  <th>Date</th>
   </tr>";

  $achievsearch= mysql_query("SELECT ch.`name`,FROM_UNIXTIME(ca.`date`,'%d.%m.%Y') FROM character_achievement ca INNER JOIN characters ch ON ca.`guid` =ch.`guid` WHERE ca.`achievement`=$achiev ORDER BY DATE;");
  while ($search = mysql_fetch_array($achievsearch))
  {
  if (!($rank % 2==0)) echo "<tr class=\"first\"> \n";
   else echo "<tr class=\"second\">";
  $rank++;
  echo "<td>" . $search[0] . "</td> \n";
  echo "<td>" . $search[1] . "</td> \n";
  echo "</tr> \n";
  }
  echo "</table>";
  break;
}
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="achiev.css"/>
</head>
<body>
<form action="?s=search" method="post">
<select name="achiev">
 <? while ($row = mysql_fetch_array($list))
 {
 $id=$row[0];
 $name=$row[1];
 echo "<option value=\"$id\">$name</option>";
 } ?>
</select>
<input type="submit"/>
</form>
<div id="top100">
<table id="top">
<tr>
  <th>Rank</th>
  <th>Name</th>
  <th>Points</th>
</tr>
<?
$rank=1;
while ($row = mysql_fetch_array($top))
  {
  if (!($rank % 2==0)) echo "<tr class=\"first\"> \n";
   else echo "<tr class=\"second\">";
  echo "<td>" . $rank . "</td> \n";
  $rank++;
  echo "<td>" . $row[0] . "</td> \n";
  echo "<td>" . $row[1] . "</td> \n";
  echo "</tr> \n";
  }
?>
</table>
</div>
<div id="footer">
                :: Created by Dasio::
</div>
</body>
</html>