Någon som "ser vad det är för fel på denna kod? Den fungerar inte såtillvida att varorna inte hämtas från databasen OBS det är inget fel på själva uppkopplingen.
// grabs all product information
$result = mysql_query("select DISTINCT maingroup from varor WHERE maingroup <> 'offerter' ORDER BY maingroup");
// counter for how many iterations have been done
$i=1;
while($row = mysql_fetch_row($result)) {
echo "<IMG ID='img_$i' SRC='images/plus.gif' border='0' onClick='javascript: Menu($i);'>";
echo "<a href='#' class='Menu' onClick='javascript: Menu($i);'><B>$row[0]</B></a><br>";
echo "<span id='ktg_$i' style='display:none;'>";
$result2 = mysql_query("select DISTINCT maingroup, secondgroup from varor WHERE maingroup = '$row[0]' ORDER BY secondgroup");
while($row = mysql_fetch_row($result2)) {
echo "<IMG ID='img_$i' SRC='images/plus.gif' border='0' onClick='javascript: Menu($i);'>";
echo "\<a href='#' class='Menu' onClick='javascript: Menu($i);'\>\<B\>$row\[0\]\</B\>\</a\>\<br\>";
echo "<span id='ktg_$i' style='display:none;'>";
$result3 = mysql_query("select DISTINCT maingroup, secondgroup, thirdgroup from varor WHERE maingroup = '$row[0]' secondgroup = '$row[1]' ORDER BY thirdgroup");
while($row = mysql_fetch_row($result3)) {
echo " <IMG SRC='images/blank.gif' border='0'> <a href=\"item_list.php?maingroup=$row[0]&secondgroup=$row[1]&thirdgroup=$row[2]\" target=\"main\">$row[1]</a><br>
";
$i=$i+1;
}
echo "</span>";
}