Miscellany

$query = "SELECT id FROM `amulets` WHERE `short_name` = '$name'";$result = mysql_query($query) or die("Error in query: $query.<br />" . mysql_error());if (mysql_num_rows($result) != 0) {  list($id) = mysql_get_row($result);  $previous = $id - 1;  $query = "SELECT * FROM `amulet` WHERE `id` = '$previous'"; 		echo "\n\t\t\t\t\t<td width=\"150\" height=\"15\" class=\"librarylinkleft\"><a href=\"amulet.php?amuletid=" .$previous. "\" title=\"Previous Creature\">&laquo; Previous</a></td>";}else {  echo "\n\t\t\t\t\t<td width=\"150\" height=\"15\" class=\"librarylinkleft\"></td>";}  echo "\n\t\t\t\t\t<td width=\"100\" height=\"15\" class=\"librarylinkcenter\"><a href=\"amulet.php\" title=\"Back to overview\">&raquo; Back &laquo; </a></td>";			$query = "SELECT id FROM `amulets` WHERE `short_name` = '$name'";$result = mysql_query($query) or die("Error in query: $query.<br />" . mysql_error());if (mysql_num_rows($result) != 0) {  list($id) = mysql_get_row($result);  $next = $id + 1;  $query = "SELECT * FROM `amulet` WHERE `id` = '$next'";		  echo "\n\t\t\t\t\t<td width=\"150\" height=\"15\" class=\"librarylinkright\"><a href=\"amulet.php?amuletid=" .$next. "\" title=\"Next Creature\">Next &raquo;</a></td>";}else {  echo "\n\t\t\t\t\t<td width=\"150\" height=\"15\" class=\"librarylinkleft\"></td>";}