Hvad er fejlen
Hvorfor virker det ikke ???<?php
function MenuLine() {
Require($_SERVER["DOCUMENT_ROOT"]."/system/db_ind.inc");
$menuID = $_GET['menuID'];
if (isset( $_GET['subID'] )) {
$subID = $_GET['subID'];
}
mysql_connect($mysql_db_host,$mysql_db_username,$mysql_db_pass) or die('Could not connect to mySQL.');
mysql_select_db($mysql_db) or ('Could not connect to db.');
$Result = mysql_query("select * from menu_punkter where MenuID = '$menuID' ");
while ($Row = mysql_fetch_array($Result)) {
echo ' [ <a href="' .$Row['menulink']. '">' .$Row['menuname']. '</a> ]<br>';
if ($Row['subID'] != '0') {
$SubResult = mysql_query("select * from menu_subpunkter where subID = $subID ");
while ($SubRow = mysql_fetch_array($SubResult)) {
echo ' [ <a href="' .$SubRow['menulink']. '">' .$SubRow['menuname']. '</a> ]<br>';
}
}
}
mysql_free_result($Result);
mysql_close();
}
?>
jeg få disse fejl >>
Notice: Undefined variable: subID in C:\vhosts\dl\sites\default\system\menu_funktion.php on line 42
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\vhosts\dl\sites\default\system\menu_funktion.php on line 43
min database se sådan ud til submenu:
Field Type Collation Attributes Null Default Extra Action
id int(11) No auto_increment Change Drop Primary Index Unique Fulltext
subID int(11) No 0 Change Drop Primary Index Unique Fulltext
menuname varchar(250) latin1_swedish_ci No Change Drop Primary Index Unique Fulltext
menulink varchar(250) latin1_swedish_ci No Change Drop Primary Index Unique Fulltext
unID int(11) No 0 Change Drop Primary Index Unique Fulltext
database til menu_ punkt:
Field Type Collation Attributes Null Default Extra Action
id int(11) No auto_increment Change Drop Primary Index Unique Fulltext
menuID int(11) No 0 Change Drop Primary Index Unique Fulltext
menuname varchar(250) latin1_swedish_ci No Change Drop Primary Index Unique Fulltext
menulink varchar(250) latin1_swedish_ci No Change Drop Primary Index Unique Fulltext
subID int(11) No 0 Change Drop Primary Index Unique Fulltext
