error = Access denied for user 'root'@'localhost' (using password: YES) Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/izolasho/public_html/vutique/library/libdb.php on line 75
select distinct(pt.frtag),count(pt.frtag) as occurences,t.ftag,rand() as ran,
count(pt.frtag) as occurences,
15 +
(
case
when count(pt.frtag) = 1 then 0
when count(pt.frtag) > 1 and count(pt.frtag) < 3 then 4
when count(pt.frtag) > 3 and count(pt.frtag) < 5 then 10
when count(pt.frtag) > 5 and count(pt.frtag) < 20 then 12
when count(pt.frtag) > 20 then 16
else 0
end
) as fontsize
from athoot2tags pt
inner join attags t on t.fid = pt.frtag
group by pt.frtag,t.ftag
order by ran desc
limit 30
Hoot - Tags Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/izolasho/public_html/vutique/library/libdb.php on line 75
select fid,fname from atcategory where flevel=0 and factive=1 ORDER BY forder