PHP5 + PostgreSQL - pg_fetch_row() returning string not array

Question

PHP5 + PostgreSQL (ubuntu 12.04) according to the doco returns an array for pg_fetch_row(). By my test results indicate that it's returning a string, is there some configuration option for this?

$db = openDatabase(<blah>);
$query = "SELECT (id,serial,tag) FROM devices ORDER BY tag ASC";
$result = pg_query($db,$query);
if ($result)
{
    while ($row = pg_fetch_row($result))
        echo "IN: $row[0] - $row[1] - $row[2]";
}

I expect to see

IN: <value> - <value> - <value>

But I get

IN: (<value>,<value>,<value>) - -

I guess this means pg_fetch_row() is returning a string not an array?!

e.g. the actual run:

IN: (10,7426573,________) - - 
IN: (7,6862,FMUX-TAG) - - 
IN: (9,6914082,L6) - -

It seems a simple problem, but I can't find an answer. I know I can parse the result, but that's kludgey.

Frank Heikens · Accepted Answer · 2012-10-09 08:18:05Z

1

Change SELECT (id,serial,tag) into SELECT id,serial,tag and you're done.

answered Oct 9, 2012 at 8:18

Frank Heikens

129k26 gold badges156 silver badges153 bronze badges

that's it. Thanks. So it was PostgreSQL (well my syntax), not PHP.

Kingsley
– Kingsley

10/09/2012 08:36:21
Commented Oct 9, 2012 at 8:36

Add a comment |

SadSamurai · Accepted Answer · 2012-10-09 08:33:51Z

1

The answer is simple - just remove brackets from SELECT statement, like this:

$query = "SELECT id,serial,tag FROM devices ORDER BY tag ASC";

otherwise it is a string in output.

edited Oct 9, 2012 at 8:33

answered Oct 9, 2012 at 8:20

SadSamurai

1116 bronze badges

Add a comment |

Collectives™ on Stack Overflow

PHP5 + PostgreSQL - pg_fetch_row() returning string not array

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related