I have a following MySQL with two parameters, $catname and $limit=1. And it is working fine.

SELECT P.*, C.Name AS CatName 
                   FROM omc_product AS P
                   LEFT JOIN omc_category AS C
                   ON C.id = P.category_id
                   WHERE C.Name = '$catname'
                   AND p.status = 'active'
                   ORDER BY RAND()
                   LIMIT 0, $limit

Now I want to add another parameter $order. $order can be either

ODER BY RAND()

or

ORDER BY product_order

in the table omc_product.

Could anyone tell me how to write this query please?

Thanks in advance.