Jump to content

[SOLVED] Multiple while loops


YourNameHere

Recommended Posts

I have several DB queries that I know should be returning results and aren't. I have a feeling it has to do with the several while loops that should be outputting the data. 

One more issue is that when I echo the num_rows they are all 0 except the first one.

BTW I checked that all variables were being populated and they were.

 

Here is my code:

 

$sql1 = "SELECT * FROM player1 where player = '$username'";
$sql2 = "SELECT * FROM player2 where player = '$username'";
$sql3 = "SELECT * FROM player3 where player = '$username'";
$sql4 = "SELECT * FROM player4 where player = '$username'";
$sql5 = "SELECT * FROM player5 where player = '$username'";
$sql6 = "SELECT * FROM player6 where player = '$username'";

$result1 = mysql_query($sql1);
$result2 = mysql_query($sql2);
$result3 = mysql_query($sql3);
$result4 = mysql_query($sql4);
$result5 = mysql_query($sql5);
$result6 = mysql_query($sql6);

$num1 = mysql_num_rows($result1);
$num2 = mysql_num_rows($result2);
$num3 = mysql_num_rows($result3);
$num4 = mysql_num_rows($result4);
$num5 = mysql_num_rows($result5);
$num6 = mysql_num_rows($result6);

 

 

while ($b < $num1){
                    $game=mysql_result($result1,$b,chatId);
                    $g="SELECT * from chats where name = '$game'";
                    $gResult= mysql_query($g);
                    $info=mysql_fetch_assoc($gResult);
                    echo "
                    <tr>
                    <td>" . $info['realName'] . "</td>
                    <td>" . $info['dm'] . "</td>
                    </tr>
                    ";
                    $b++;                
                    }                    
                    while ($b < $num2){
                    $game=mysql_result($result2,$b,chatId);
                    $g="SELECT * from chats where name = '$game'";
                    $gResult= mysql_query($g);
                    $info=mysql_fetch_assoc($gResult);
                    echo "
                    <tr>
                    <td>" . $info['realName'] . "</td>
                    <td>" . $info['dm'] . "</td>
                    </tr>
                    ";
                    $b++;                
                    }
                    
                    while ($b < $num3){
                    $game=mysql_result($result3,$b,chatId);
                    $g="SELECT * from chats where name = '$game'";
                    $gResult= mysql_query($g);
                    $info=mysql_fetch_assoc($gResult);
                    echo "
                    <tr>
                    <td>" . $info['realName'] . "</td>
                    <td>" . $info['dm'] . "</td>
                    </tr>
                    ";
                    $b++;                
                    }
                    
                    while ($b < $num4){
                    $game=mysql_result($result4,$b,chatId);
                    $g="SELECT * from chats where name = '$game'";
                    $gResult= mysql_query($g);
                    $info=mysql_fetch_assoc($gResult);
                    echo "
                    <tr>
                    <td>" . $info['realName'] . "</td>
                    <td>" . $info['dm'] . "</td>
                    </tr>
                    ";
                    $b++;                
                    }
                                        
                    while ($b < $num5){
                    $game=mysql_result($result5,$b,chatId);
                    $g="SELECT * from chats where name = '$game'";
                    $gResult= mysql_query($g);
                    $info=mysql_fetch_assoc($gResult);
                    echo "
                    <tr>
                    <td>" . $info['realName'] . "</td>
                    <td>" . $info['dm'] . "</td>
                    </tr>
                    ";
                    $b++;                
                    }

                    while ($b < $num6){
                    $game=mysql_result($result6,$b,chatId);
                    $g="SELECT * from chats where name = '$game'";
                    $gResult= mysql_query($g);
                    $info=mysql_fetch_assoc($gResult);
                    echo "
                    <tr>
                    <td>" . $info['realName'] . "</td>
                    <td>" . $info['dm'] . "</td>
                    </tr>
                    ";
                    $b++;                
                    }

 

I have tried changing the variable $b to something else in each loop but that didnt work either.

Link to comment
https://forums.phpfreaks.com/topic/180255-solved-multiple-while-loops/
Share on other sites

what I am trying to do is....

 

I have a chat room, that can accept 6 people + a moderator. That moderator has to invite those 6 people. so I have 6 sql tables player1 - player6. This function is going to iterate through each table and find each occurrence of the this persons name and display it on a page. This is an invite.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.