Code: Select all
<?php
$pubs = pg_query("SELECT * FROM pubs WHERE $musts ORDER BY name");
while($pub = pg_fetch_assoc($pubs)){
$query = "SELECT id, keywords, date, content, title, blurb, rank(vector, q), headline(content, q) FROM {$pub['code']}.articles, to_tsquery('" . str_replace(' ', '&', $phrase) . "') AS q WHERE vector @@ q AND published=true ORDER BY rank(vector, q) DESC";
$matches = pg_query($db, $query);
if (pg_num_rows($matches) === 0) {
echo "none.";
} else {
while ($article = pg_fetch_assoc($matches)){
echo "sql data....";
}
}
}
?>