Home

"; /*#######iterate places */ $sql = "select * from place order by place_id"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { $place_name = $row["place_name"]; $place_id = $row["place_id"]; echo "[$place_name] "; } mysql_free_result($result); /* */ echo "
"; echo "

"; $sql = "select * from links,place,site where active=1 and links.site_id = site.site_id "; $sql = $sql." and links.place_id=place.place_id"; $sql = $sql." and site_domain = '$site' order by place.place_id limit $startat,$endat"; $result = mysql_query($sql); $last_place=""; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { $link_text_clickable = $row["link_text_clickable"]; $link_blurb = $row["link_blurb"]; if ($link_blurb==""){ $link_blurb="
"; } else { $link_blurb=$link_blurb."

"; } $link_url = $row["link_url"]; $place_name = $row["place_name"]; $place_id = $row["place_id"]; if ($last_place != $place_name){ $last_place = $place_name; $sitelinks[] = "[$place_name]"; $linkdata[] = "
"."

$place_name

"; } $num_rows = mysql_num_rows($result); //echo $row["link_id"]; $linkdata[]= "$link_text_clickable
$link_blurb"; } mysql_free_result($result); mysql_close($dblink); ?>

<< previous page

next page >>




<< previous page

next page >>



Home