Thread: order by not working ocrectly in 01/19/01 snapshot?

order by not working ocrectly in 01/19/01 snapshot?

From
"Mike Sears"
Date:
I'm curently using the jan 19 snapshot and every thing works great till I try to order by a specific column in php.
 
$thread_result = pg_exec($db, "SELECT thread FROM $main_db ORDER BY thread;");
 
any sugestions as to what might be the problem?
 
Mike

Re: order by not working ocrectly in 01/19/01 snapshot?

From
"Oliver Elphick"
Date:
"Mike Sears" wrote:
  >I'm curently using the jan 19 snapshot and every thing works great till I t=
  >ry to order by a specific column in php.
  >
  >$thread_result =3D pg_exec($db, "SELECT thread FROM $main_db ORDER BY threa=
  >d;");
  >
  >any sugestions as to what might be the problem?

You haven't described the problem.

(NOT "Everything works great") is hardly adequate for diagnosis.

What is the structure of the table? what are its contents? what
results do you get? what did you expect to get?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If anyone has material possessions and sees his
      brother in need but has no pity on him, how can the
      love of God be in him?"
                                    I John 3:17



Re: order by not working ocrectly in 01/19/01 snapshot?

From
Tom Lane
Date:
"Mike Sears" <mike@neutrinostudios.com> writes:
> I'm curently using the jan 19 snapshot and every thing works great till I t=
> ry to order by a specific column in php.

> $thread_result =3D pg_exec($db, "SELECT thread FROM $main_db ORDER BY threa=
> d;");

And?

            regards, tom lane