My last Question: Query only gets the first one

[techgearfree]

My page displays information from my mysql tables.



<?php
if ($modules) {
$admininfo['Fraud']['info'][] = array(
'name' => 'Users and Referrals',
'link' => $file,
);
return;
}
include './../includes/adminheader.php';

$post_userid = $_POST['userid'];

if ( $_POST && $post_userid != NULL ) {
// page that confirms that it went thru okay? finished page?

/********** START DISPLAY INFORMATION *********/
$query = "SELECT * FROM users WHERE id = '$post_userid'";
$result = mysql_query($query);
while($result3 = mysql_fetch_array($result)) {
$user_id = $result3['id'];
$user_username = $result3['username'];
$user_password = $result3['password'];
$user_ip = $result3['ip'];
$user_name = $result3['name'];
$user_signupcookieip = $result3['cookieip'];
$user_street = $result3['street'];
$user_city = $result3['city'];
$user_state = $result3['state'];
$user_zip = $result3['zip'];
$user_referral = $result3['referral'];
$user_resolution = $result3['resolution'];
$user_signuptime = $result3['signuptime'];
$user_os = $result3['os'];
$user_osnumber = $result3['osnumber'];
$user_browser = $result3['browser'];
$user_number = $result3['number'];
$user_ieversion = $result3['ieversion'];
$query_offer = "SELECT * FROM offer_credit WHERE user_id = '$post_userid'";
$result_offer = mysql_query($query_offer);
while($result_offer3 = mysql_fetch_array($result_offer)) {
$offer_complete = 1;
}
if ( $offer_complete == 1 ) {
$user_completed_offer = "Yes";
}
else {
$user_completed_offer = "No";
}

$query = "SELECT * FROM logins WHERE username = '$user_username'";
$result = mysql_query($query);
while($result3 = mysql_fetch_array($result)) {
$user_login .= $result3['login'].'<br>';
$user_loginips .= $result3['loginip'].'<br>';
$user_logincookieip .= $result3['logincookieip'].'<br>';
$user_los .= $result3['os'].'<br>';
$user_losnumber .= $result3['osnumber'].'<br>';
$user_lbrowser .= $result3['browser'].'<br>';
$user_lnumber .= $result3['number'].'<br>';
$user_lieversion .= $result3['ieversion'].'<br>';
$user_loginres .= $result3['loginres'].'<br>';

$table = "<TR>
<TD><CENTER>" . $user_id . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_username . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_password . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_name . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_street . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_city . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_state . "</CENTER></TD>
<TD><CENTER>" . $user_zip . "</CENTER></TD>
<TD><CENTER>" . $user_referral . "</CENTER></TD>
<TD><CENTER>" . $user_completed_offer . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_signuptime . "</CENTER></TD>
<TD><CENTER>" . $user_ip . "</CENTER></TD>
<TD><CENTER>" . $user_signupcookieip . "</CENTER></TD>
<TD><CENTER>" . $user_resolution . "</CENTER></TD>
<TD><CENTER>" . $user_os . "</CENTER></TD>
<TD><CENTER>" . $user_osnumber . "</CENTER></TD>
<TD><CENTER>" . $user_browser . "</CENTER></TD>
<TD><CENTER>" . $user_number . "</CENTER></TD>
<TD><CENTER>" . $user_ieversion . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_login . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_loginips . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_logincookieip . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $user_loginres . "</CENTER></TD>
<TD><CENTER>" . $user_los . "</CENTER></TD>
<TD><CENTER>" . $user_losnumber . "</CENTER></TD>
<TD><CENTER>" . $user_lbrowser . "</CENTER></TD>
<TD><CENTER>" . $user_lnumber . "</CENTER></TD>
<TD><CENTER>" . $user_lieversion . "</CENTER></TD>
</TR>";
}

$query = "SELECT * FROM users WHERE referral = '$post_userid'";
$result = mysql_query($query);
while($result3 = mysql_fetch_array($result)) {
$offer_complete = 0;
$referral_id = $result3['id'];
$referral_username = $result3['username'];
$referral_password = $result3['password'];
$referral_ip = $result3['ip'];
$referral_name = $result3['name'];
$referral_signupcookieip = $result3['cookieip'];
$referral_street = $result3['street'];
$referral_city = $result3['city'];
$referral_state = $result3['state'];
$referral_zip = $result3['zip'];
$referral_referral = $result3['referral'];
$referral_resolution = $result3['resolution'];
$referral_signuptime = $result3['signuptime'];
$referral_os = $result3['os'];
$referral_osnumber = $result3['osnumber'];
$referral_browser = $result3['browser'];
$referral_number = $result3['number'];
$referral_ieversion = $result3['ieversion'];
$query_offer = "SELECT * FROM offer_credit WHERE user_id = '$referral_id'";
$result_offer = mysql_query($query_offer);
while($result_offer3 = mysql_fetch_array($result_offer)) {
$offer_complete = 1;
}
if ( $offer_complete == 1 ) {
$referral_completed_offer = "Yes";
}
else {
$referral_completed_offer = "No";
}

$table = $table . "<TR>
<TD><CENTER>" . $referral_id . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_username . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_password . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_name . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_street . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_city . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_state . "</CENTER></TD>
<TD><CENTER>" . $referral_zip . "</CENTER></TD>
<TD><CENTER>" . $referral_referral . "</CENTER></TD>
<TD><CENTER>" . $referral_completed_offer . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_signuptime . "</CENTER></TD>
<TD><CENTER>" . $referral_ip . "</CENTER></TD>
<TD><CENTER>" . $referral_signupcookieip . "</CENTER></TD>
<TD><CENTER>" . $referral_resolution . "</CENTER></TD>
<TD><CENTER>" . $referral_os . "</CENTER></TD>
<TD><CENTER>" . $referral_osnumber . "</CENTER></TD>
<TD><CENTER>" . $referral_browser . "</CENTER></TD>
<TD><CENTER>" . $referral_number . "</CENTER></TD>
<TD><CENTER>" . $referral_ieversion . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_login . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_loginips . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_logincookieip . "</CENTER></TD>
<TD NOWRAP><CENTER>" . $referral_loginres . "</CENTER></TD>
<TD><CENTER>" . $referral_los . "</CENTER></TD>
<TD><CENTER>" . $referral_losnumber . "</CENTER></TD>
<TD><CENTER>" . $referral_lbrowser . "</CENTER></TD>
<TD><CENTER>" . $referral_lnumber . "</CENTER></TD>
<TD><CENTER>" . $referral_lieversion . "</CENTER></TD>
</TR>";
}

$tvars = array(
'TABLE' => $table,
'USERNAME' => $username,
'USER_ID' => $user_id
);
pparse('admin/users_referrals_list');
/********** END DISPLAY INFORMATION *********/




Now, I want to put this code into the page:


//selects from my logins table all the rows where the username is equal to a variable I set above this portion of the code;
$query = "SELECT * FROM logins WHERE username = '$referral_username'";
$result = mysql_query($query);
while($result3 = mysql_fetch_array($result)) {
\\In the rows where the previous was true, it sets a variable to a certain column in that row;
$referral_login .= $result3['login'].'<br>';
$referral_loginips .= $result3['loginip'].'<br>';
$referral_logincookieip .= $result3['logincookieip'].'<br>';
$referral_los .= $result3['os'].'<br>';
$referral_losnumber .= $result3['osnumber'].'<br>';
$referral_lbrowser .= $result3['browser'].'<br>';
$referral_lnumber .= $result3['number'].'<br>';
$referral_lieversion .= $result3['ieversion'].'<br>';
$referral_loginres .= $result3['loginres'].'<br>';
}


I put it in right after:


$referral_ieversion = $result3['ieversion'];
$query_offer = "SELECT * FROM offer_credit WHERE user_id = '$referral_id'";
$result_offer = mysql_query($query_offer);
while($result_offer3 = mysql_fetch_array($result_offer)) {
$offer_complete = 1;
}
if ( $offer_complete == 1 ) {
$referral_completed_offer = "Yes";
}
else {
$referral_completed_offer = "No";
}


However, it only shows the information from the small snippet of code for the very first user (this stuff):


$referral_lnumber .= $result3['number'].'<br>';
$referral_lieversion .= $result3['ieversion'].'<br>';
$referral_loginres


Is only shown for the very first user it finds that meets the query:

FROM logins WHERE username = '$referral_username'";

So, if I have this as my users table (only shows 3 columns)

www.techgearfree.com/images/bad draw.jpg

pretend that $referral_username is equal to 1

[techgearfree]

So, it should display the information from my logins table for @walla and @yahoo people. Because they both have the referral value of 1.
My problem is that it only shows the info for the very first one it finds (the first one is @walla b/c it is first on the list.)
Anyone know what is wrong? I read some where online that if a row is indexed, it will stop the search after finding the first entry. If this is true, then what row should I un-index?

Thanks

[Ultragames]

<?
$query = "SELECT * FROM users WHERE id = '$post_userid'";
$result = mysql_query($query);
$num = mysql_num_rows($result);
?>

Add the $num to it. Use a loop to go throug hall rows of the result, and try this:

<?
for($x=0; $x<$num; $x++){
$user_id = mysql_result($result3, $x, 'id');
// ect..
}
?>

[techgearfree]

I do not think I explained what the problem is correctly. When I have this part of the code in:



$query = "SELECT * FROM logins WHERE username = '$referral_username'";
$result = mysql_query($query);
while($result3 = mysql_fetch_array($result)) {
$referral_login .= $result3['login'].'<br>';
$referral_loginips .= $result3['loginip'].'<br>';
$referral_logincookieip .= $result3['logincookieip'].'<br>';
$referral_los .= $result3['os'].'<br>';
$referral_losnumber .= $result3['osnumber'].'<br>';
$referral_lbrowser .= $result3['browser'].'<br>';
$referral_lnumber .= $result3['number'].'<br>';
$referral_lieversion .= $result3['ieversion'].'<br>';
$referral_loginres .= $result3['loginres'].'<br>';
}



It only shows the first person (like in the pic: www.techgearfree.com/images/bad draw.jpg it would only give me @walla and not at walla and yahoo if I searched for people w/ referral #1.)

However, with out that small section of code in my main code (see above post), it shows all the referrals for the person (just without the login information that the small section gives me).

If, that is what you thought the question was, would you be more specific as to your answer b/c I do not understand where to place the code you posted.


Thanks