<dbconnect>
if ($id) {
- $query = sprintf ("SELECT *,organisation.name as organisation "
+ $fields = array ('compound.name',
+ 'compound.hostname',
+ 'compound.ip',
+ 'compound.ident',
+ 'compound.location',
+ 'compound.status',
+ 'organisation.name as organisation');
+ $query = sprintf ("SELECT %s "
."FROM compound,organisation "
- ."WHERE location = organisation.id AND compound.id = %d", $id);
+ ."WHERE location = organisation.id AND compound.id = %d",
+ implode (",", $fields), $id);
$sth = pg_exec ($dbh, $query) or die_query("Cannot issue query!", $query);
if (pg_NumRows ($sth) > 0) {