$query = "SELECT id FROM `amulets` WHERE `short_name` = '$name'";
$result = mysql_query($query) or die("Error in query: $query.
" . 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« Previous | ";
}
else {
echo "\n\t\t\t\t\t | ";
}
echo "\n\t\t\t\t\t» Back « | ";
$query = "SELECT id FROM `amulets` WHERE `short_name` = '$name'";
$result = mysql_query($query) or die("Error in query: $query.
" . 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\tNext » | ";
}
else {
echo "\n\t\t\t\t\t | ";
}