interests.php

一个全功能的国外博客商业程序

<?
include "header.php";

if(isset($_GET['i'])) { $i = str_replace("+", " ", $_GET['i']); } else { header("Location: $homepage"); exit(); }
if(mysql_num_rows(mysql_query("SELECT * FROM bhost_interests WHERE name='$i'")) == 0) { header("Location: $homepage"); exit(); }

// GET INTEREST
$interest = mysql_fetch_assoc(mysql_query("SELECT * FROM bhost_interests WHERE name='$i' LIMIT 1"));

echo $head;
echo "
<h2>$interests1</h2>
$interests2 <b>$interest[name]</b>:
<br><br>
";

// SHOW INTERESTED USERS
$users = mysql_query("SELECT username, show_name, fname, display_name, gender FROM bhost_users WHERE interests LIKE '%-$interest[int_id]-%'");
while($user = mysql_fetch_assoc($users)) {
if($user[show_name] == 1) { $name = $user[fname]; } else { $name = $user[display_name]; }
if($user[gender] == "Female") { $icon = "user_female.gif"; } elseif($user[gender] == "Male") { $icon = "user_male.gif"; } else { $icon = "user_nogender.gif"; }
echo "
<div style='margin-top: 3px;'>
<a href='".url("profile", "$user[username]")."'><img src='".url("/images/", "images/$icon")."' border='0' style='vertical-align: middle;'></a> <b><a href='".url("index", "$user[username]")."'>$user[username]</a></b> - $name<br>
</div>
";

}

echo $foot;

?>