order by in c code??

I am writing an ap in c, everything works fine
except the order by portion of my query.

I am generating my query like this:

sprintf(querystr, "select * from %s order by %s", table, field);

however, the returned query is not sorted, it comes out as
the order the data is stored in the table.

Any ideas????

Thanks.

ken

kvp(at)ocol(dot)com