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 'ASC LIMIT 0, 10' at line 28<p>HERE: Select with Limit</p><p>SELECT pr_id,
        pr_ca_id,
        pr_active,
        pr_new_date,
        pr_renew_date,
        pr_title,
        pr_catalog_no,
        pr_price,
        pr_cost,
        pr_sku,
        pr_quantity,
        pr_image,
        pr_image_2,
        pr_description,
        pr_attrib_1,
        pr_attrib_2,
        pr_attrib_3,
        pr_attrib_4,
        pr_attrib_5,
        pr_attrib_6,
        pr_attrib_7,
        pr_attrib_8,
        pr_attrib_9,
        pr_attrib_10,
        pr_uni_id 
        FROM cat_products  
        WHERE pr_ca_id = '1159'   
        AND pr_active = 1 ORDER BY   ASC LIMIT 0, 10 </p>