How to add a line value to a fixed position in an array using PHP and MySQL

advertisements

I need some help. I need to keep one row value from table in bottom position in an array using PHP and MySQL . I am explaining the table below.

db_designation:

id      name

1       aaa

2       bbbb

3       Other

4       tttt

I am explaining my query below.

$sqldeg=mysqli_query($connect,"select * from db_designation order by id desc");
while ($row=mysqli_fetch_array($sqldeg)) {
            $desdata[]=array("did"=>$row['id'],"dname"=>$row['name']);
}

Here I need this id->3 name->Other row from table value always come in last in the array i.e-$desdata . Please help me.


You could do it at query, with ordering before getting to php with.

By id:

ORDER BY (CASE WHEN `id`=3 THEN 1 ELSE 0 END) ASC, `id` DESC

Or by name:

ORDER BY (CASE WHEN `name`='Other' THEN 1 ELSE 0 END) ASC, `id` DESC

this will append 1 when id or name matches, otherwise zero (0), and will order in ASCENDING order.

So your query would be:

$sqldeg=mysqli_query($connect,"select * from db_designation ORDER BY (CASE WHEN `id`=3 THEN 1 ELSE 0 END) ASC, `id` DESC");
while ($row=mysqli_fetch_array($sqldeg)) {
            $desdata[]=array("did"=>$row['id'],"dname"=>$row['name']);
}