"; //padding echo "
"; echo "
" . $vlogo . "
" . $vpagetop . "
"; echo "
"; echo "
"; $vcount=0; $sql="SELECT * FROM tCategories WHERE cAlive='Y' ORDER BY cSort "; $result = $conn->query($sql);if ($result->num_rows > 0) {while ($row = $result->fetch_assoc()) { echo "
"; $vcat[$vcount]=$row["cID"]; $vcount=$vcount+1; }} echo "
"; //echo "
cat " . $vcat[1]; //set up category divs //171ttt=61; $divlist=""; $n=count($vcat); for ($x = 0; $x <$n; $x++) { $reec=$vcat[$x]; //echo "
Cat " . $vcat[$x]; //set distinct list of subcats $ddcat=""; $sql="SELECT DISTINCT sCategorySub FROM tStations WHERE sCategoryMain=" . $reec . " AND sAlive='Y' "; $result = $conn->query($sql);if ($result->num_rows > 0) {while ($row = $result->fetch_assoc()) { //$ddcat=$ddcat . "
" . $row["sCategorySub"] . "
"; $ddcat=$ddcat . "
"; $ddcat=$ddcat . "
"; }} $sql="SELECT * FROM tCategories WHERE cID=" . $reec . " AND cAlive='Y' "; $result = $conn->query($sql);if ($result->num_rows > 0) {while ($row = $result->fetch_assoc()) { $divname="DIV" . $row["cCatName"]; $divlist=$divlist . $divname . ","; $vShowName=$row["cShowName"]; $vShowPlay=$row["cShowPlaylink"]; $vShowWeb=$row["cShowWebsite"]; $vShowSubCat=$row["cShowSubCat"]; $vShowBlurbCategory=$row["cShowBlurbCategory"]; $vShowBlurbStation=$row["cShowBlurbStation"]; $vShowLimit=$row["cLimit"]; //104xxxxxxx echo "
"; echo "
" . $row["cCatName"] . "
"; if($vShowBlurbCategory<>'N') { echo "
" . $row["cBlurb"] . "
"; } if($row["cPublic"]<>"N") { echo "
Create your Listing
"; //echo "
"; echo "
"; } //122xxxxxx if($vShowSubCat<>"N") { echo $ddcat; echo "
"; } $sql="SELECT * FROM tStations WHERE sCategoryMain=" . $reec . " AND sAlive='Y' ORDER BY sSort, sCategorySub,sWhere "; $result = $conn->query($sql);if ($result->num_rows > 0) {while ($row = $result->fetch_assoc()) { // items in category if($vShowName<>'N') { echo "
" . $row["sName"] . "
"; } $vreadonly=""; if($row["sWebX"]<>"N") { $vreadonly=" style='display:none;' "; } //tttttt187 if($vShowPlay<>'N') { echo "
"; echo "
"; } if($vShowWeb<>'N') { echo "
"; echo "
"; echo "
"; } echo "
"; //echo "
"; echo "
"; echo "
"; }}//stations echo "
";//category div }} }//loop echo "
"; echo "
"; echo "
"; echo ""; //main echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "Show only items which have the word below in their
Suburb or Area
(leave it empty to show everything)
"; echo "
"; echo "Show only items which have the word below in their
Key Word
(leave it empty to show everything)
"; echo "
"; echo "
"; echo "
" . $vfooter . "
" . $vcopyright . "
"; echo "
"; echo ""; // row padding ?>