count results?

[nikomou]

is it possible to assign a number to a result in loop?

e.g.

<?php
$iddaddress = "localhost";
$iddusername = "xxxx";
$iddpassword = "xxxx";
$idddb = "xxxx";
$iddconn = mysql_connect($iddaddress, $iddusername, $iddpassword);
$iddrs = mysql_select_db($idddb, $iddconn);
$iddsql="SELECT * FROM handset GROUP BY handset";
$iddrs = mysql_query($iddsql, $iddconn);
$iddj = 0;
while($iddrow = mysql_fetch_array($iddrs)) { 
$iddmake = $iddrow[make];
$iddhand = $iddrow[handset];
$idddetails = $iddrow[details];

echo("This is result number: $resultnumber");
  $j++; 
}
mysql_close();
?>

Thanks for your help.

[thetestingsite]

$iddj = 0;
while($iddrow = mysql_fetch_array($iddrs)) { 
$iddmake = $iddrow[make];
$iddhand = $iddrow[handset];
$idddetails = $iddrow[details];

echo("This is result number: $iddj");
  $iddj++; 
}

Should work.

[mburt]

for ($i=0;$i=-1;$i++) {
//do something;
}

I wouldn't recommend it, though. Could cause your computer to crash, but I believe some servers only allow so many to go through before it stops. But, yes, that script will loop indefinitely.

[nikomou]

hey.. thanks for your replies..

i've tried the 1st code, but it seems to show all the deals as number 0

any ideas why?! cheers.

[mburt]

Because the while loop does not iterate through a number, it only returns the values until the condition is false.

[boxxertrumps]

$num = 0;
while (....) {
....
echo $num; num++;
}

[thetestingsite]

$num = 0;
while (....) {
....
echo $num; num++;
}

That's basically what I did, with the exception of incorporate it into the OP's code.

[Twey]

This is what for loops are for:

for($resultnumber = 1; $iddrow = mysql_fetch_array($iddrs); ++$resultnumber)

[mburt]

Shouldn't it be:

for($resultnumber = 1; $iddrow = count(mysql_fetch_array($iddrs)); ++$resultnumber)

Seeings it returns an array?

[djr33]

Not sure if this is related, but for counting, this is helpful--
http://www.php.net/manual/en/functio...l-num-rows.php