<?php
$order = array("Z","Srilanka","34", "Canada", "India", "USA");
$array = array(
array('id' => 7867867, 'title' => 'USA'),
array('id' => 3452342, 'title' => 'India'),
array('id' => 1231233, 'title' => 'Srilanka'),
array('id' => 5867867, 'title' => 'Z'),
);
usort($array, function ($a, $b) use ($order) {
$pos_a = array_search($a['title'], $order);
$pos_b = array_search($b['title'], $order);
return $pos_a - $pos_b;
});
print_r($array);
?>
select SQL_CALC_FOUND_ROWS from <tablename> where flag = 1 limit 10 and then select found_rows();
Comments
Post a Comment