Answer by Chris Petersn for i fetched products from mysqli data and how to sort product within the results with help of input type
$orderfield = 'product_id';
if (isset($_GET['orderfield'])) {
if ($_GET['orderfield']=='someotherfield') {
$orderfield = 'someotherfield';
}
}
$orderdir = 'DESC';
if (isset($_GET['orderdir'])) {
if ($_GET['orderdir']=='asc') {
$orderdir = 'ASC';
}
}
$cpro_query.=" ORDER BY ' . $orderfield . ' ' . $orderdir;
Tuesday 22nd August 2017 4:43 am