Mysql获取数组和排序

Question

I have a SQL table and I want a reverse sorting how I can? these codes work well for sorting 1 2 3 4 5 6 7 8 9 ... But I want to last data on top. ... 9 8 7 6 5 4 3 2 1 to table all data

    $adsql="SELECT meta_value FROM ue_usermeta where meta_key LIKE 'billing_first_name' and user_id IN ( SELECT user_id FROM ue_stm_lms_user_quizzes WHERE status LIKE '%pass%') ";
$sorgulaad=mysqli_query($baglanti,$adsql);

$soyadsql="SELECT meta_value FROM ue_usermeta where meta_key LIKE 'billing_last_name' and user_id IN ( SELECT user_id FROM ue_stm_lms_user_quizzes WHERE status LIKE '%pass%') ";
$sorgulasoyad=mysqli_query($baglanti,$soyadsql);

$mailsql="SELECT meta_value FROM ue_usermeta where meta_key LIKE 'billing_email' and user_id IN ( SELECT user_id FROM ue_stm_lms_user_quizzes WHERE status LIKE '%pass%') ";
$sorgulamail=mysqli_query($baglanti,$mailsql);


for($i = 1; $sonucad=mysqli_fetch_array($sorgulaad,MYSQLI_ASSOC) AND $sonucsoyad=mysqli_fetch_array($sorgulasoyad,MYSQLI_ASSOC) AND  $sonucmail=mysqli_fetch_array($sorgulamail,MYSQLI_ASSOC); $i++){


echo '<tr class="data">';
        echo ' 
        <td class="icerik">
        <span class="icerik">'.$i.'</span></td>

        <td class="icerik">
        <span class="icerik">'.$sonucad['meta_value'].'</span></td>

        <td class="icerik">
        <span class="icerik">'.$sonucsoyad['meta_value'].'</span></td>

        <td class="icerik">
        <span class="icerik">'.$sonucmail['meta_value'].'</span></td>
        </tr>
            ';
    }

Answer 1

Have you tried to sort data Descending? an example:

SELECT * FROM Customers ORDER BY CustomerName DESC;

https://www.w3schools.com/sql/sql_ref_desc.asp