weird php+mysql problem...

[flatpooks]

i have a query that should pull 4 or 5 items from a db table in the order defined by one of the fields called 'seq'

if i run the query in mysqlcc or whatever it works perfectly

if i run it from my php code it returns the data items sorted in the reverse order!!

has anybody seen anything like this before? or am i losing the plot? maybe i should quit programming and become a herb farmer in new mexico after all?

platform: linux
mysql: 4.0.20
php: 4.3.7

:queasy:

[devinemke]

you are using the "seq" variable to set the ORDER BY clause of your query?

post the code

[flatpooks]

yah
everything is as its supposed to be ... like i said ... the query works perfectly in mysql directly

"select ra_id from ranswers where recruit_id=$rid and reqd='Y' order by seq"

($rid = 6, say)

[devinemke]

what is "seq"? integer? varchar?

[flatpooks]

seq is a smallint

it can range from 1 thru say 30 max