Sort news

Good day.

I want to sort the news by date and name, but it does not work, or rather if you put ORDER BY $order_db in the query, then the output of the news stops altogether, but stops because of $order_db , an error occurs. Although this sorting is for another, everything works there. Here is the code:

  /* =====Сортировка===== */ $order_p = array( 'datea' => array('по дате добавления - к последним', 'date ASC'), 'dated' => array('по дате добавления - с последних', 'date DESC'), 'titlea' => array('от А до Я', 'title ASC'), 'titled' => array('от Я до А', 'title DESC') ); $order_get = clear($_GET['order']); // получаем возможный параметр сортировки if(array_key_exists($order_get, $order_p)){ $order = $order_p[$order_get][0]; $order_db = $order_p[$order_get][1]; }else{ // по умолчанию сортировка по первому элементу массива order_p $order = $order_p['datea'][0]; $order_db = $order_p['datea'][1]; } /* =====Сортировка===== */ $all_news = news($order_db); 

 function news($order_db){ global $connection; $query = "SELECT news_id, title, anons, date FROM news ORDER BY $order_db DESC LIMIT $start_pos, $perpage"; $res = mysqli_query($connection, $query); $all_news = array(); while($row = mysqli_fetch_assoc($res)){ $all_news[] = $row; } return $all_news; } 

Well, the sorting output itself:

 Сортировать:&nbsp; <ul id="menuuu"> <li><?=$order?> <ul> <?php foreach($order_p as $key => $value): ?> <?php if($value[0] == $order) continue; ?> <li><a href="ссылку потом пропишу" class="sort-bot"><?=$value[0]?></a></li> <?php endforeach; ?> </ul> </li> </ul> 

Who can find a mistake, tell me, please. )