Thread: order by not working ocrectly in 01/19/01 snapshot?
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
"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
"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