comic_nav.php

<?php
function nav_element($label, $comic_url, $comic_id, $r, $desc = false)
{
  if ($desc) {
    $order = "pubtime DESC, id DESC";
    $op = "<";
  } else {
    $order = "pubtime, id";
    $op = ">";
  }
  $query = "SELECT slug FROM ns_updates WHERE comic={$comic_id} AND published = 1 AND updtype IN (\'c\', \'i\') AND pubtime <= NOW()";
  if(is_array($r)) {
    $query .= " AND (pubtime {$comic_id} \"{$op}\" OR (pubtime = \"{$r['pubtime']}\" AND id {$op} {$r['id']}))";
  }
  $query .= " ORDER BY {$order} LIMIT 1";
  $result = $conn->query($query);
  if($result->num_rows) {
    $arr = $result->fetch_assoc();
    $current_slug = (is_array($r) ? $r['slug'] : $r);
  }
  if ($arr['slug'] != $current_slug) {
    return "<li><a href=\"{$comic_url}/comic/{$arr['slug']}\">{$label}</a></li>";
  } else {
    die("I guess something went wrong");
  }
}
?>

Se mer i PHP-dokumentasjonen

Sjekk også tenary operators.

$current_slug = (is_array($r) ? $r['slug'] : $r);