Multiple while loops

Posted on 16th Feb 2014 07:03 pm by admin

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:

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);


Code: 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.

Your Answer:

Login to answer

Other forums

download directory onto C drive
I am attempting (if this is possible) to write a routine to automatically dump the contents of a dir

check if string contain only a-z/A-Z
Is where any way to check if string contains only a-z/A-Z, without writing an array with all possibl

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

Mail functionality from localhost to server
Hi

I am facing problem of mail functionality.

When i tested mail functionality in my

From Header Showing 'Unkown' In Hotmail? Why?
Code: $to = $row_GetID['email_addr'].',sales@mywebaddress.co.uk';
$subject = 'Thank you for you

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

Login logout link help
Hi all,

Im new to php and Im having trouble creating a login/logout link for my page that dis

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

Warning: session_start() headers already sent error - Driving me Nuts!
I am trying my sister in laws site and I keep getting an error with my coding. I am more of a design

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and