select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=19 order by rand() limit 10

Men Dresses -> Casual Shirts

Casual Shirts

VSI Brands Black Slim Fit Shi

₹0₹ 599

Casual Shirts

Roadster Olive Green Washed Ca

₹0₹ 1250

Casual Shirts

Blue Shirts

₹0₹ 450

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP5\ext\php_mssql.dll' - The specified module could not be found. in Unknown on line 0