I try to order records an then limit the selection to the first 20 records: SELECT * FROM tb_test ORDER BY id LIMIT 0,20 not working :-( SELECT * FROM tb_test LIMIT 0,20 -> is working SELECT * FROM tb_test ORDER BY id -> is working Is there a different syntax required? Heinrich