I'm exeriencing a strange problem with pg_fetch_all
(postgresql
) : it never returns me more tan 2 columns
For exemple, this code :
$dbh = pg_connect("host=localhost dbname=dbname user=user password=passwd");
$query = "SELECT m.id, v.nom, v.id FROM machine m, version v WHERE m.id_version = v.id;";
$result = pg_query($dbh, $query);
$array = pg_fetch_all($result);
print_r($array);
Only prints me m.id
, v.nom
!
If I paste the exactly same SQL request in pg_my_admin, each colomn is returned.
If I parse my result as
$array = array();
while ($row = pg_fetch_row($result)) {
$array[] = $row;
}
it works perfectly. Why ?