| |
include ("config.inc");
mysql_pconnect( "localhost", "$username", "$password") or die( "Unable to connect to SQL server");
mysql_select_db( "$db_name") or die( "Unable to select database");
$result = mysql_query("SELECT category from linklist where site='$site' AND approved='1'");
$array_category = array();
while ($row = mysql_fetch_array ($result)) {
$array_temp = array($row[0]);
$array_category = array_merge($array_category, $array_temp);
}
mysql_free_result ($result);
$array_category = array_unique($array_category);
reset ($array_category);
while (list ($key, $val) = each ($array_category)) {
?>
echo $val; ?>
$query = "SELECT name, description, url from linklist where category='$val' AND site='$site' AND approved='1' order by name";
$insert = MYSQL_QUERY($query);
$number = MYSQL_NUM_ROWS($insert);
$i = 0;
while ($i < $number) {
$name = mysql_result($insert,$i,"name");
$name = stripslashes($name);
$description = mysql_result($insert,$i,"description");
$description = stripslashes($description);
$url = mysql_result($insert,$i,"url");
$url = stripslashes($url);
$link_url = ("$name"); ?>
| |
echo $link_url; ?>
if ($description!="") { ?>
(
echo $description; ?>
)
} ?>
|
$i++;
} ?>
} ?>
Please add your links here.
|
 |