You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY no asc' at line 1query : SELECT * FROM contact_groups WHERE user_no= ORDER BY no asc