Publications SUP CICS

Books:

<php> $mysqli = new mysqli(«localhost», «cics», «cics123», «cics»);

/* check connection */ if (mysqli_connect_errno()) {

  printf("Connect failed: %s\n", mysqli_connect_error());
  exit();

} $query = «SET NAMES 'utf8'»;

$dummy = $mysqli→query($query);

$query = «SELECT af.artikkel, af.forfatter, af.arbeidsinnsats, a.id, a.publiseringsaar,

          a.kategori, a.overskrift_eng, a.publikasjonssted_eng, a.registrert, f.id, GROUP_CONCAT(f.fullt_navn ORDER BY af.arbeidsinnsats DESC SEPARATOR ', ')
        FROM artikkel_forfattere AS af
          LEFT JOIN artikler AS a ON af.artikkel = a.id
          LEFT JOIN forfattere AS f ON af.forfatter = f.id
        GROUP BY af.artikkel ORDER BY a.publiseringsaar DESC, a.kategori ASC, a.registrert DESC";

echo $query; if ($result = $mysqli→query($query)) { $dato = date(«Y»); $kategori = 0; echo »<strong><a name=\«» . $dato. «\»>« . $dato . »</a></strong><br>«; /* fetch object array */ while ($row = $result→fetch_row()) { if 1) { echo »</ul>«; echo »<strong><a name=\«» . $row[4]. «\»>« . $row[4]. »</a></strong><br>«; $dato–; } if ($row[5] != $kategori) { $kategori = $row[5]; switch ($kategori) { Book chapter

          	case 1:
          		//echo "</ul>";
        			echo "<em>Book chapters:<br></em>";
        			echo "<ul>";
        			echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>";
        			break;
        		// Journal
          	case 2:
          	  echo "</ul>";
          	  echo "<em>Journals:<br></em>";
          	  echo "<ul>";
          	  echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>";
          	  break;
          	// Conference Paper
          	case 3:
          	  echo "</ul>";
          	  echo "<em>Conference papers: <br></em>";
          	  echo "<ul>";
          	  echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</div></li>";
          	  break;
          	// Plenary talk
          	case 4:
          	  echo "</ul>";
          	  echo "<em>Plenary talk: <br></em>";
          	  echo "<ul>";
          	  echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>";
          	  break;
          }
        } else {
          echo "<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</li>";
      }
  }
  /* free result set */
  $result->close();

}

/* close connection */ $mysqli→close(); </php>

1)
$row[4] != $dato) & ($row[4] < $dato