=$siteName; ?>'s Directory...
$sql = "SELECT id, nome, link FROM link_categoria";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)) {
$catID = $row["id"]; $category = $row["nome"]; $linkCat = $row["link"];
echo ''.$category.' ';
$s = "SELECT id, nome, link FROM link_subcat WHERE cat = ".$catID."";
$q = mysql_query($s);
while (list($subID, $subName, $linkSub) = mysql_fetch_array($q)) {
$qnt = mysql_query("SELECT * FROM link_back WHERE subcat = '$subID' AND (site = '$site' OR site = 'ALL')");
$total = @mysql_num_rows($qnt);
if ($total)
echo ' | '.$subName.' ('.$total.')';
else
echo ' | '.$subName.'';
}
echo ' |
';
}
?>
$sql = "SELECT id, nome, link FROM link_categoria";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)) {
$catID = $row["id"]; $category = $row["nome"]; $linkCat = $row["link"];
echo '';
$s = "SELECT id, nome, link FROM link_subcat WHERE cat = ".$catID."";
$q = mysql_query($s);
while (list($subID, $subName, $linkSub) = mysql_fetch_array($q)) {
$qnt = mysql_query("SELECT * FROM link_back WHERE subcat = $subID");
$total = mysql_num_rows($qnt);
if ($total) {
echo '';
$qu = mysql_query("SELECT * FROM link_back WHERE subcat=$subID AND (site='$site' OR site='ALL')");
while ($r = mysql_fetch_array($qu)) {
$title = $r["titulo"];
$desc = $r["descricao"];
$link1 = $r["link"];
echo '
';
}
}
}
echo ' ';
}
?>
|
USA
Tel.: 1-888-457-3266
Fax: (1) (732) 909-2966
|
Brazil
Tel.: (55)(71) 3113-4205
Fax: (55)(71) 3113-4203
|
UK
Tel.: 44-207-669-4493
Fax: (44)(20)7900-6555
|
|