kramster

Hi all, I have a strange problem. I am using the MySQL query SELECT * FROM crh_log WHERE logdetix=$detix ORDER BY logix ASC I have this exact query in two scripts, each gives a different result. logix is the primary key to the table. There are two rows that satisfy this query. One script returns the rows on ascending order of logix, the other is the reverse. I've tried ORDER BY different variables and in one script it never makes a difference - it's as if MySQL is ignoring the ORDER by clause. The MySQL code in the code snippets in attached file are identical. The only difference is that logix is displayed in the able in one script and not in the other.