stop mysql_fetch_array when reach username

Question

I have this code to get the list of users from the database and sort them by score.

$sql="SELECT * FROM users ORDER BY score DESC";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){

What I want to do, is to stop the loop proces, when the proces reach a decided username.

It looks like a leaderboard potentially showing a list of users down to the current users name - this assumption could be wrong though. It could be done using a MySQL variable of some kind but that's not really what the user asked. — Simon at The Access Group, Apr 05 '13 at 09:33

score 1 · Accepted Answer · answered Apr 05 '13 at 09:28

1

Use break with if condition

while($rows=mysql_fetch_array($result)){
    if($rows['name'] == 'yourname') {
        break;
    }else {
        //your code
    }
}

answered Apr 05 '13 at 09:28

Yogesh Suthar

30,424
18
72
100

score 1 · Answer 2 · answered Apr 05 '13 at 09:29

1

You can do this

$sql="SELECT * FROM users ORDER BY score DESC";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){
  if($row['username']=='DecidedUser')
   break;
}

answered Apr 05 '13 at 09:29

Mahendra

908
1
18
38

score 1 · Answer 3 · answered Apr 05 '13 at 09:36

1

Use WHERE in mysql query like this.

$sql="SELECT * FROM users WHERE user_name='targetUserName' ORDER BY score DESC";
$result=mysql_query($sql);

Here user_name is mysql fieldname in users table.

answered Apr 05 '13 at 09:36

Bharat Chodvadiya

1,644
4
20
31

score 0 · Answer 4 · answered Apr 05 '13 at 09:28

0

use break;

$sql="SELECT * FROM users ORDER BY score DESC";
$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){
  if(Reached_at_user_name)
   break;
}

answered Apr 05 '13 at 09:28

Tapas Pal

7,073
8
39
86

score 0 · Answer 5 · edited May 23 '17 at 10:32

break; is your friend

http://php.net/manual/en/control-structures.break.php

while($rows=mysql_fetch_array($result)){
    if (
        $row['username'] == 'username'
    ) {
        break;
    }
}

An alternative approach depending on your intention would be to just change the SQL query to do what you want instead, i.e. something like the following which uses the @includeThis variable to keep track of if it's hit the intended username yet

$sql="
    SELECT 
        u.*, 
        @includeThis AS includeThis,
        @includeThis := IF(u.username = 'TargetUserName',0,@includeThis) AS updateIncludeThis
    FROM users u, (SELECT @includeThis := 1) d 
    ORDER BY u.score DESC
    HAVING includeThis = 1
";

Additionally you shouldn't be using the mysql_ functions any more, and instead using mysqli_ or PDO. Why shouldn't I use mysql_* functions in PHP?

score 0 · Answer 6 · answered Apr 05 '13 at 09:28

inside your while you want to add something along the lines of.

if($rows['username'] == "targetUserName"){return;}

You could also use break; instead of return, however with return you can return true; to let your script know your function found the username, if required :)

stop mysql_fetch_array when reach username

6 Answers6