Home
$place_name] ";
}
mysql_free_result($result);
*/
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);
?>
Home