mysql_query LIMIT won't work

[bodge]

Hi Devbest, the LIMIT in my mysql_query won't work

    $userstatus = mysql_query("SELECT * FROM `users_status` WHERE `user_id` ='".$id."' ORDER BY `status_id` LIMIT 10");

It just shows the newest column data and doesn't show any other previous data, even though LIMIT 10 should display the first 10 results from the database.

while ($row = mysql_fetch_array($userstatus, MYSQL_ASSOC)){
   
        $status = $row['status_message'];
   
    }


echo $status

database table:

Thanks inadvanced

 

[Markshall]

Do you not have to put ASC or DESC after 'ORDER BY `status_id`' ?

 

[bodge]

Do you not have to put ASC or DESC after 'ORDER BY `status_id`' ?

Doesn't work if I do, just returns blank.

 

[Markshall]

Show the output you're currently getting.

 

[bodge]

Show the output you're currently getting.

Output: UWOT
(The last inserted data by the user id 48)

Nothing more but that.

 

[Markshall]

Are you sure this doesn't work?

$userstatus = mysql_query("SELECT * FROM `users_status` WHERE `user_id` ='".$id."' ORDER BY `status_id` DESC LIMIT 10");

 

[bodge]

Are you sure this doesn't work?

$userstatus = mysql_query("SELECT * FROM `users_status` WHERE `user_id` ='".$id."' ORDER BY `status_id` DESC LIMIT 10");

Fixed, I added

    while ($row = mysql_fetch_array($userstatus, MYSQL_ASSOC)){
        echo "<br>";
        echo $row['status_message'] . "";
        echo "<br>";
   
    }

Underneath the $userstatus