Setting up a $i++

XeRoZeN

I'm having troubles making my script count the total amount of accounts.

while($rows = mysql_fetch_array($result, MYSQL_NUM)) {
$i=0;
printf("<p>Username: %s <br> Password: %s</p>", $rows[0], $rows[1], $i++);
}

Output:
Username: BLAH
Password: BLAH

Username: BLAH2
Password: BLAH2

Username: BLAH3
Password: BLAH3

Total Accounts: 1

I added 3 accounts but it shows that there's only 1. I've looked all over google on how to fix this but I couldn't find one.

ThaSpY

<?
$i=0;
while($rows = mysql_fetch_array($result, MYSQL_NUM)) { 
printf("<p>Username: %s <br> Password: %s</p>", $rows[0], $rows[1], $i++);
}
?>

Your problem lied with the $i=0;
Every time the loop ran, it set $i back to zero, so move it out of the loop so it stays on track.

XeRoZeN

Smacks himself with a hedge hammer HOW COULD I BE SO BLIND! Thanks very much ThaSpy.. I practically spent over 1 hour staring at whats wrong lol I'm such a newb ^{^;}

TheDefender

Technically, you wouldn't even need to do the $i=0 and $i++ thing...

This should work just fine:

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

    printf("<p>Username: %s <br> Password: %s</p>", $rows[0], $rows[1]); 
}

Or even, for that matter, why do the MYSQL_NUM argument... Why not just use the index names themselves?

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

    echo "<p>Username: ".$rows['username']."<br /> Password: ".$rows['password']."</p><br /><br />"; 
}

(Just curious is all)

XeRoZeN

What are you talking about? The snippet you just posted doesn't calculate the total numbers of accounts. Also is there some way for me to use sprintf()? because I need to set a variable but the the pain is telling it when to use a = and not use a .=

Like..

$accounts = sprintf("Username: %s <br> Password: %s", $rows[0], $rows[1]);
$accounts .= sprintf("Username: %s <br>  Password: %s", $rows[0], $rows[1]);

But the problem is when its doing the "while" command it loops and it confuses it and etc..

TheDefender

If you're counting the total number of accounts, why not use mysql_num_rows?

$numberofaccounts = mysql_num_rows($result);

At any rate, if you want to use the .=, then set the accounts to a blank value prior to the loop, and then in the loop, do the .=

Weedpacket

Ah, all this hassle because people don't think of using for() loops....

$total_accounts = mysql_num_rows($result);
$load_o_text='';
for($i=0; $i<$total_accounts; $i++)
{
    list($username,$pasword) = mysql_fetch_row($result);
    $load_o_text.='Username: '.$username.' <br> Password: '.$password.'<br>';
}

XeRoZeN

I thought about using the for() loop but never wanted to test that theory yet..and hey thanks for the help 🙂 I needed it thanks very much I appreciate it.

TheDefender

Thanks for the followup Weed... I was watching a movie, and was at a cool part of it, and didn't particularly want to write out the code just yet (until my movie ended), but you beat me to it by the time my movie ended... OK, I am off to bed now, you all have a good night/day (wherever in the world you are).