<?php
session_start();
 
dbconnect.....
 
 
 
 
function generate_list($parentid) {
 
      $check = false;
 
      $query = mysql_query("SELECT * FROM kategorier WHERE parentID=".$parentid) or die(mysql_error());
 
      
      while($row = mysql_fetch_object($query)) {
            
	  $check_child = mysql_query("SELECT * FROM kategorier WHERE parentID=".$row->ID) or die(mysql_error());
		
	  $sjekka =  mysql_query("SELECT animal.kategori, kategorier.tittel FROM animal, kategorier WHERE animal.kategori=".$row->ID) or die(mysql_error());	
	
	  $selected = ('SELECTED');
 
	  if($sjekka <=0) {
		  return $selected;
	  }
            if(mysql_num_rows($check_child)) {
                  
                  print "<option " . $selected." name='".$row->tittel."'  label='".$row->tittel."'>";
				  print $row->tittel;
                  print "</option>";
				  print  ('heia');
                  generate_list($row->ID);
                  
 
                  
            }else{
				  
				  
                  print " <option " . $selected." name='".$row->tittel."'  value='$row->tittel'>&nbsp;&nbsp;&nbsp;&nbsp;".$row->tittel."</option>";
            
            }
      }
}
 
 
$file_to_be_edited= $_GET["name"];
 
$query  = "SELECT lydid, opprinneligfilnavn, tittel, kortbeskrivelse, kategori, fullurl, infoomfil FROM animal WHERE lydid='$_GET[name]'";
$result = mysql_query($query);
 
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
	print "<FORM METHOD=POST ACTION=\"update.php\">";
	print "<INPUT TYPE=\"hidden\" NAME=\"lydid\" VALUE=\"{$row['lydid']}\">" ;
	print "Opprinnelig filnavn: {$row['opprinneligfilnavn']}<br>" ;
	print "Tittel : <INPUT TYPE=\"text\" NAME=\"tittel\" VALUE=\"BLABLA\"><br>" ;
	print "Kort beskrivelse : <INPUT TYPE=\"text\" NAME=\"kortbeskrivelse\" VALUE=\"{$row['kortbeskrivelse']}\"><br>" ;
 
	print "Kategori : <SELECT NAME=\"kategori\">";
generate_list(0);
	print "</SELECT><br>";
 
	print "Full URL : <INPUT TYPE=\"text\" NAME=\"fullurl\" VALUE=\"{$row['fullurl']}\"><br>";
	print "Informasjon : <INPUT TYPE=\"text\" NAME=\"infoomfil\" VALUE=\"{$row['infoomfil']}\"><br>";
	print "<INPUT TYPE=\"submit\">";
	print "</FORM>" ;
 
}
 
 
?>