Her er koden bag det (det er også i PHP):
<?php
echo '<script language="javascript" type="text/javascript">';
echo 'var arr = [';
$result = mysql_query("SELECT * FROM hovedkategorier");
$i = 1;
while ($row = mysql_fetch_array($result)) {
echo '["'.$row[navn].'", [';
$x = 1;
$result2 = mysql_query("SELECT * FROM kategorier WHERE hovedkategori = '$row[navn]'");
while ($row2 = mysql_fetch_array($result2)) {
echo '["'.$row2[kategori].'",';
$l3 = "";
$y = 1;
$result3 = mysql_query("SELECT * FROM links WHERE kategori = '$row2[kategori]'");
while ($row3 = mysql_fetch_array($result3)) {
if (mysql_num_rows($result3) != $y) {
$l3 .= '"'.$row3[navn].'",';
} else {
if (mysql_num_rows($result2) != $x) {
$l3 .= '"'.$row3[navn].'"';
} else {
$l3 .= '"'.$row3[navn].'"]]';
}
}
$y++;
}
if ($l3 == "") {
$l3 = '""]]';
}
if (mysql_num_rows($result) != $i) {
echo '['.$l3.']],';
} else {
if (mysql_num_rows($result2) != $x) {
echo '['.$l3.']],';
} else {
echo '['.$l3.']]';
}
}
$x++;
}
$i++;
}
echo '];';
echo 'function createOpts(sel){';
echo 'var s = new Array();';
echo 'var num = 0, txt = "arr";';
echo 'var ar = opt = null;';
echo 'var n = sel.selectedIndex;';
echo 'var args = createOpts.arguments.length;';
echo 'for(var i=1;args>i;i++){';
echo 's[i-1] = document.getElementById(createOpts.arguments[i]);';
echo 'if(s[i-1]==sel)num=i;';
echo '}';
echo 'if(args>1){';
echo 'if(s[num])sel = s[num];';
echo 'else return;';
echo '}';
echo 'if(n==0&&args>1){';
echo 'for(i=num;args>i+1;i++){';
echo 's[i].length = 0;';
echo 'opt = document.createElement(\'OPTION\');';
echo 's[i].appendChild(opt);';
echo 'opt.value = "";';
echo 'opt.text = "\74-- Vælg --";';
echo '}';
echo 'return true';
echo '};';
echo 'for(i=0;num>i;i++){';
echo 'txt+="["+(s[i].selectedIndex-1)+"][1]";';
echo '}';
echo 'ar = eval(txt);';
echo 'sel.length = 0;';
echo 'opt = document.createElement(\'OPTION\');';
echo 'sel.appendChild(opt);';
echo 'opt.value = "";';
echo 'opt.text = "-- Vælg --";';
echo 'for(i=0;ar.length>i;i++){';
echo 'opt = document.createElement(\'OPTION\');';
echo 'sel.appendChild(opt);';
echo 'if(typeof ar[i] == \'object\'){';
echo 'opt.value = ar[i][0];';
echo 'opt.text = ar[i][0];';
echo '}else{';
echo 'opt.value = ar[i];';
echo 'opt.text = ar[i];';
echo '}';
echo '}';
echo 'if(args>num+2){';
echo 'for(i=num+1;args-1>i;i++){';
echo 's[i].length = 0;';
echo 'opt = document.createElement(\'OPTION\');';
echo 's[i].appendChild(opt);';
echo 'opt.value = "";';
echo 'opt.text = "\74-- Vælg --";';
echo '}';
echo '}';
echo '}';
echo '</script>';
?>
<form name="validerlinkform" method="post" action="validerlink.php" border="0">
<?php
$result = mysql_query("SELECT * from validerlink");
while ($row = mysql_fetch_array($result)) {
list($addedYear,$addedMonth,$addedDay) = split('-',$row[added]);
$addedstampeddate = mktime(12,0,0,$addedMonth,$addedDay,$addedYear);
$added = date("d.m.Y",$addedstampeddate);
$status = "";
if ($row[aktiver] == 0) {
$status = "- aktiver";
}
echo '<tr bgcolor="f7f7f7">';
echo '<td height="24" class="infoheadline"><div align="left"><input type="radio" name="link" value="'.$row[id].'"></div></td>';
echo '<td height="24" class="infoheadline">'.$row[navn].'</td>';
echo '<td height="24" class="infoboxtext">'.$added.'</td>';
if ($row['kategoritype'] == 0) {
echo '<td height="24"><select name="hovedkategori'.$row[id].'" class="infoboxtext" style="width: 150px" onChange="createOpts(this,\'hovedkategori'.$row[id].'\',\'underkategori'.$row[id].'\');"><option selected="selected">Hovedkategori</option></select></td>';
echo '<td width="155" height="24"><div align="left"><select name="underkategori'.$row[id].'" class="infoboxtext" style="width: 150px"><option selected="selected"><-- Vælg Hovedkategori</option></select></div></td>';
} else {
echo '<td height="24"><select name="hovedkategori-'.$row[id].'" class="infoboxtext" style="width: 150px" onChange="createOpts(this,\'hovedkategori'.$row[id].'\');"><option selected="selected">Hovedkategori</option></select></td>';
echo '<td height="24"><div align="left"><input type="text" class="boxborder" value="'.$row[kategori].'" /></td>';
}
echo '<script language="javascript" type="text/javascript">createOpts(document.getElementById(\'hovedkategori'.$row[id].'\'));</script>';
echo '<script language="javascript" type="text/javascript">document.validerlinkform.hovedkategori'.$row[id].'.'.$row[hovedkategori].'.selected="true";</script>';
echo '<td height="24" class="infoboxtext"><em>'.$status.'</em></td>';
echo '<td><input name="aktiver" type="button" class="boxborder" style="width: 50px" onClick=\'java script:window.location="validerlink.php?do=aktiver&id='.$row[id].'"\' value="Aktiver" /></td>';
echo '<td><input name="vistilmelding" type="button" class="boxborder" style="width: 74px" onClick=\'java script:window.location="validerlink.php"\' value="Tilmelingsdata" /></td>';
echo '</tr>';
}
unset ($result);
?>
Det sjove er at det er createOpts scriptet som laver fejl, når jeg har denne linje i scriptet.. (document.validerlinkform....) men hvis jeg fjerner den, så virker det fint nok... skal altså bare have den til at selecte det valgte, udfra databasen..
Ny bruger
Nybegynder
Opret
Preview
