"; $content .= "a.fsn_directory:link, a.fsn_directory:visited { color:#006699; font-weight:bold; text-decoration:none; }"; $content .= "a.fsn_directory:hover, a.fsn_directory:active { text-decoration:underline; }"; $content .= ""; require ("/private/database_functions.php"); require ("/private/functions.inc"); $db = ConnectDatabase("fsn_content"); $referer = $_SERVER['HTTP_REFERER']; $ip = $_SERVER['REMOTE_ADDR']; mysql_query("insert into widget_stats values ('', 'dir.php.js', '".date("Y-m-d H:i:s")."', '$referer', '$ip')"); CloseDatabase($db); $db = ConnectDatabase("adams_florist"); $addr_city = $city; $addr_state = $state; include("/htdocs/public_html/include/track_directory_search.php"); $city = addslashes($city); $state = addslashes($state); $sql = "select name_shop, address, addr_city, addr_state, id_num, tel_tollfree, url from clients where active >= 0 and date_anniv >= curdate() and addr_city = '$city' and addr_state = '$state' order by rand()"; $result = mysql_query($sql); $content .= "

"; $content .= "

"; $content .= "

"; $content .= "

"; $content .= "

"; $content .= "Florists serving
".ucwords($city).", $state"; $content .= "

"; $content .= "

"; while ($row = mysql_fetch_assoc($result)) { if ($pastfirstrow) $content .= "

"; else $pastfirstrow = true; $name = addslashes($row['name_shop']); $address = addslashes($row['address']); $city = addslashes($row['addr_city']); $state = addslashes($row['addr_state']); $id = $row['id_num']; $url = addslashes($row['url']); $phone = Format_Tel(addslashes($row['id_num'])); $tollfree = Format_Tel(addslashes($row['tel_tollfree'])); $phone_display_result = mysql_query("SELECT id_num FROM clients_nolocal WHERE id_num = '$shop_id'"); $phone_display_rows = mysql_num_rows($phone_display_result); if ($phone_display_rows > 0 ) { $local_display_flag = "No"; } else { $local_display_flag = "Yes"; } $content .= "

"; if (trim($url) == "") { $content .= "$name
"; } else { $content .= "$name
"; } $content .= "$address
"; $content .= "$city, $state"; if ($local_display_flag == "Yes") { $content .= " - $phone"; } if ($tollfree) { $content .= " - $tollfree"; } $content .= "

"; } $sql = "SELECT clients.name_shop, clients.address, clients.addr_city, clients.addr_state, clients.id_num, clients.url FROM clients INNER JOIN clients_servebys ON clients.id_num = clients_servebys.id_num WHERE (clients_servebys.city='$city') AND (clients_servebys.state='$state') AND (clients.date_anniv >= CURDATE()) AND (clients.active >= '0') ORDER BY RAND()"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)) { if ($pastfirstrow) $content .= "

"; else $pastfirstrow = true; $name = addslashes($row['name_shop']); $address = addslashes($row['address']); $city = addslashes($row['addr_city']); $state = addslashes($row['addr_state']); $phone = Format_Tel(addslashes($row['id_num'])); $id = $row['id_num']; $url = addslashes($row['url']); $content .= "

"; if (trim($url) == "") { $content .= "$name
"; } else { $content .= "$name
"; } $content .= "$address
"; $content .= "$city, $state - $phone"; $content .= "

"; } $content .= "

"; $content .= "

"; $content .= "Find a local florist with our directory!"; $content .= "

"; CloseDatabase($db); ?> var element=document.getElementById("FSN_Directory"); if (element) { element.innerHTML = ''; }