~~NOCACHE~~
====== Publications SUP CICS ======
//Books://
  * **P.J. From, J.-T. Gravdahl and K.Y. Pettersen** Modeling and Control of Vehicle-Manipulator Systems, Springer-Verlag, To be published.
  * **Fossen, T. I. and H. Nijmeijer (2011) (eds.).** Parametric Resonance in Dynamical Systems, Springer-Verlag, November 2011.

<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 (($row[4] != $dato) & ($row[4] < $dato)) {
          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>