Zendframework / PgSQL fetchAll orderby

Posted by viMaL on Stack Overflow See other posts from Stack Overflow or by viMaL
Published on 2010-04-29T06:47:38Z Indexed on 2010/04/29 6:57 UTC
Read the original article Hit count: 514

Filed under:
|
|
|
|

i have a pgsql table with fields id, identifier, name.

  id serial NOT NULL,
  identifier character varying(16),
  name character varying(128)

I want to fetchAll values from the table orderby identifier.

but identifier is having values

12, 100, 200, 50

and after $table->fetchAll(null, 'identifier'); is giving the result

100, 12, 200, 50

but I want the result as

12, 50, 100, 200

or using a direct query?

© Stack Overflow or respective owner

Related posts about zend-framework

Related posts about php