كود PHP:
$bars_sql = mysql_query("SELECT barid, barname FROM bars ORDER BY barid ASC");
while ($bars_row = mysql_fetch_array($bars_sql, MYSQL_ASSOC))
{
extract ($bars_row);
echo 'Main : '.$barname;
$links_sql = mysql_query("SELECT linkid, link, linkname, linkbar FROM links WHERE linkbar='$barid'");
$links_num = mysql_num_rows($links_sql);
if ($links_num > 0) {
echo '<br />';
while ($links_row = mysql_fetch_array($links_sql, MYSQL_ASSOC))
{
extract($links_row);
echo 'Main : '.$barname'. -> Sub : '.$linkname.' <br />';
}
} else {
echo '<br />';
}
mysql_free_result($links_sql);
}
mysql_free_result($bars_sql);