How to Use Limit Query in 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.

You're missing error reporting stackoverflow.com/questions/1053424/… — Saad Suri
– Saad Suri, Commented Apr 16, 2018 at 8:12

Klodian · Accepted Answer · 2018-04-16 08:23:04Z

1

Your code is ok , but check if your query is fetching any row from db.

 $select_query_sender = "select * from member where status='1' ORDER BY 

 member_id ASC LIMIT 1";

 $run_sender = mysqli_query($con,$select_query_sender);

 if($run_sender->num_rows > 0 ){

    while ($row_sender = mysqli_fetch_array($run_sender)) {  

        echo $row_sender['member_no']; // echo member_no
   }

 }else{
   echo "no row";
 }

answered Apr 16, 2018 at 8:23

Klodian

7116 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dilip Solanki · Accepted Answer · 2018-04-16 08:15:19Z

0

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 ;

answered Apr 16, 2018 at 8:15

Dilip Solanki

4373 silver badges13 bronze badges

1 Comment

Melebius Over a year ago

Thank you for this code snippet, which might provide some limited, immediate help. A proper explanation would greatly improve its long-term value by showing why this is a good solution to the problem and would make it more useful to future readers with other, similar questions. Please edit your answer to add some explanation, including the assumptions you’ve made. Please comment your changes to the original code at least.

Collectives™ on Stack Overflow

How to Use Limit Query in php mysql?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related