<?php

include('connect.inc.php');

$q = (isset($_GET['term']) ? pg_escape_string($_GET['term']) : false);

$sql = "SELECT label, COUNT(*) nb FROM hdabo_tag A, hdabo_taggedsheet B WHERE A.id=B.tag_id ".($q?"AND label ILIKE '%$q%' ":"")."GROUP BY label ORDER BY nb DESC LIMIT 20";

$rq = pg_query($sql);

echo json_encode(pg_fetch_all($rq));

pg_free_result($rq);

pg_close();

?>