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/function.mysql-num-rows.php

[mburt]

I often use:

$query = "SELECT * FROM table";
$result = mysql_query($query);
$num = mysql_num_rows($result);
for ($i = 0;$i < $num;$i++)
$fields = mysql_result($result,$i,"myfield");

mysql_num_rows returns the number of rows anyways.

[nikomou]

Shouldn't it be:

for($resultnumber = 1; $iddrow = count(mysql_fetch_array($iddrs)); ++$resultnumber)
Seeings it returns an array?

the count seemed to work.. but it just created 15000 results, which were all the same.. then firefox crashed!

[Twey]

Haha, whoops -- I think it should have been
for($resultnumber = 1; $iddrow = mysql_fetch_array($iddrs); ++$resultnumber)I didn't really look, just inserted code around what was already there :)

[mburt]

So calling the array directly will give you it's length?

[nikomou]

twey, is that not the same code you posted before?! :confused:

I didnt know where to put it, so i tried before, then after the while statement.. but both just show 1 as the result..

[Twey]

Like this:
<?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);

for($resultnumber = 1; $iddrow = mysql_fetch_array($iddrs); ++$resultnumber) {
$iddmake = $iddrow['make'];
$iddhand = $iddrow['handset'];
$idddetails = $iddrow['details'];

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

[nikomou]

thanks twey and everyone else!! works great!