Heej mensen,
Ik heb een probleem waar jullie mij vast mee kunnen helpen. Op de link hieronder staat het resultaat. Zoals je ziet worden 3 limousines 6 keer getoond. Dit moet 1 keer zijn. Wie kan mij helpen? Alvast bedankt.
http://i31.tinypic.com/qx7614.jpg
CODE
--------------------------------
<?php
$dbhost = 'localhost';
$dbusername = '*';
$dbuserpassword = '*';
$default_dbname = '*';
$db = mysql_connect($dbhost,$dbusername,$dbuserpassword);
mysql_select_db("***", $db);
/*** Menu weergaven ***/
$query = mysql_query("
SELECT *
FROM menu
WHERE parent_menuID = '1' AND active = '1'
ORDER by seq
",$db);
echo mysql_error();
?>
<?php
// start
while($row = mysql_fetch_assoc($query)){
// start 2
$query2 = mysql_query("
SELECT *
FROM menu
WHERE parent_menuID = '102' AND active = '1' AND verwijderd = '0'
ORDER by seq
",$db);
echo mysql_error();
while($row1 = mysql_fetch_array($query2)){
echo '<li><a href="#" title="'.$row1['menu_name'].'">'.$row1['menu_name'].'</a>' ;
echo '</li>';
}
//einde 2
$menu_name_clean = $row['menu_name'];
$menu_name_clean=str_replace("&","_",$menu_name_clean);
$menu_name_clean=str_replace(" ","_",$menu_name_clean);
$menu_name_clean = stripslashes($menu_name_clean);
$site_menu = "
<li>
<a href=\"?page=".$menu_name_clean."&menuID=".($query2['menuID'])."&pageID=".($query2['pageID'])."\">
".stripslashes($row['menu_name']).' - '.$row['menuID']."
</a>
</li>\n";
echo $site_menu;
}
//echo $site_menu;
?>
1.069 views
knop om je tekst aan te passen.