SELECT * FROM jane_mainoptions WHERE jane_mainoptions.mainoptions_products_id = ORDER BY mainoptions_price ASC You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mainoptions_price ASC' at line 1