'no' ORDER BY weightedscore DESC"; } else { $sql = "SELECT * FROM pods WHERE adminrating <> -1 AND hidden <> 'yes' AND signup = 1 ORDER BY weightedscore DESC"; } $result = pg_query($dbh, $sql); if (!$result) { die("Error in SQL query: " . pg_last_error()); } $numrows = pg_num_rows($result); echo ""; echo $numrows; ?> pods that are open for signup now. Click column names to sort and find a pod. Show as: Map | Simple Table | Advanced Table
Diaspora Pod? | Uptime %.">? | Active Users? | Location? | Services Offered? | " . $row["domain"] . " ? | ";
"";
echo "" . $row["uptimelast7"] . "% | "; echo "" . $row["active_users_halfyear"] . " | "; if ($country_code == $row["country"]) { echo "" . $row["country"] . " | \n"; } else { echo "" . $row["country"] . " | \n"; } echo ""; if ($row["service_facebook"] == "t") {echo "";} if ($row["service_twitter"] == "t") {echo "";} if ($row["service_tumblr"] == "t") {echo "";} if ($row["service_wordpress"] == "t") {echo "";} echo " | \n"; if ($tt == 4) { echo <<
---|