Hi, I'm haveing a slight problem sorting records in an access database.
$cur= odbc_exec( $cnx, "SELECT * FROM servers_tbl ORDER by '$sort' $order");
If I take the "order by" stuff out, it sorts the table automaticly by the first field in the DB.
But when I try to sort it based on colums, it jumbles up in no particular order. No matter what colum I choose to sort by, it comes back everytime in a the same jumbled order.
Keep in mind I'm a complete newb here, however I've gotten a very similar line of code to work using a MySQL db.
Hey tips would be much appreciated.
$cur= odbc_exec( $cnx, "SELECT * FROM servers_tbl ORDER by '$sort' $order");
If I take the "order by" stuff out, it sorts the table automaticly by the first field in the DB.
But when I try to sort it based on colums, it jumbles up in no particular order. No matter what colum I choose to sort by, it comes back everytime in a the same jumbled order.
Keep in mind I'm a complete newb here, however I've gotten a very similar line of code to work using a MySQL db.
Hey tips would be much appreciated.