====== Publications ======

<php>

$mysqli = new mysqli("localhost", "tempo", "RsKGJxbQnG9CSFb9", "tempo");



/* 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>