product LIKE '%$terms%' and cate = '$cate' ORDER BY rank
cate|editor|edit_date|product|rank|cate2|spec|pic_name1
id|cate|editor|edit_date|product|rank
id|cate|editor|edit_date|product|rank|cate2|spec
pic_name1