如何在php mysql中使用限制查询？

Question

Frist Member database value:-

 member_id = 1;
 member_no= 001;
 status = '2';

2nd Member database value

 member_id = 2;
 member_no= 002;
 status = '1';

3rd Member database value

member_id = 3;
member_no= 003;
status = '2';

My Php Query

$select_query_sender = "select * from member where status='1' ORDER BY member_id ASC LIMIT 1";
   $run_sender = mysqli_query($con,$select_query_sender);
   while ($row_sender = mysqli_fetch_array($run_sender)) {        
    $member_no_sender = $row_sender['member_no'];
    echo $member_no_sender;    }

I try to Retrive Status 1 Member list using Limit Query, I except Output to member_no= 002; but output nothing to show, What i missing Please Help Any one.

Answer 1

Try...

$select_query_sender = "select * from member where status='1' ORDER BY member_id ASC LIMIT 1";
$run_sender = mysqli_query($con,$select_query_sender);
$row_sender = mysqli_fetch_object($run_sender);
echo $row_sender->member_no ;