Other website you might find useful...
Here are a collection of useful web sites that I have come across. Please feed free to get in touch with others that you have found useful. No responsibility is taken for the content of external sites which may change without prior warning.
Browse our links by the following categories:
OUTPUT;
$i = 0;
$query = "select linkcategory.category_id as category_id, linkcategory.category_name as category_name
from linkcategory
left join links_categ as l on linkcategory.category_id = l.category_id
where (l.usr='' or l.usr is null or stat=1)
group by category_name
order by category_name";
$result=mysql_query($query);
$num_rows = mysql_num_rows($result);
$delimiter = ceil(mysql_num_rows($result)/3);
while($record=mysql_fetch_object($result))
{
if($i/$delimiter == floor($i/$delimiter))
$output .= "\n";
$output .= "category_id\" class = \"category\">$record->category_name
\n";
if(($i+1)/$delimiter == floor(($i+1)/$delimiter)|| $i+1 == $num_rows)
$output .= " | \n";
$i++;
}
mysql_free_result($result);
$output .=<<
OUTPUT;
$query = "select c.category_id as cat_id, c.category_name as category, c.category_name IS NULL AS isnull, website, title, descr
from links_categ as l
left outer join linkcategory as c on c.category_id=l.category_id
where (l.usr='' or l.usr is null or stat=1)
order by isnull ASC, category ";
$result=mysql_query($query);
while($record=mysql_fetch_object($result)) {
if ($cat != $record->category && !empty($cat))
$output .= "Return to categories
\n";
if ($cat != $record->category) {
$output .= "cat_id\">$record->category
\n";
$cat = $record->category;
}
$output .= "website\" target=\"_blank\"> $record->title
$record->descr
\n";
}
$output .= "Return to categories
\n";
mysql_free_result($result);
$output .= "";
?>