".getPopWord($dir)." tag / tag combinations\n"; $dsn = "mysqli://$user:$passwd@$host/$db"; $conn =& DB::connect($dsn); if (DB::isError($conn)) { die ("Cannot connect: " . $conn->getMessage() . "\n"); } $conn->query("SET NAMES utf8"); $result =& $conn->query("SELECT tag1, tag2, c_total, c_node, c_way, c_relation FROM tagfriends ORDER BY c_$order $dir LIMIT $skip, $limit"); if (DB::isError($result)) { die ("SELECT failed: " . $result->getMessage() . "\n"); } $dirA = array("total" => $dir, "node" => $dir, "way" => $dir, "relation" => $dir); $dirA[$order] = $invdir; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; $i = 1; while ($row =& $result->fetchRow()) { if($i % 2) { $style="odd"; } else { $style="even"; } printf('', $style, $row[0], displayTag($row[0]), $row[1], displayTag($row[1]), displayNum($row[2]), displayNum($row[3]), displayNum($row[4]), displayNum($row[5])); echo "\n"; $i++; } echo "
tag 1tag 2usesnodewayrelation
%3$s%5$s%6$s%7$s%8$s%9$s
\n"; $result->free(); $conn->disconnect(); $next = $skip + $limit; echo "".getOrdWord($dir)." tag / tag combinations\n"; $prev = max($skip - $limit, 0); echo "".getOrdWord($invdir)." tag / tag combinations\n"; $more = $limit+25; echo "More tag / tag combinations\n"; echo "".getPopWord($invdir)." tag / tag combinations\n"; echo "Back to index page\n"; ?>