count results?

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

e.g.

PHP Code:

---

<?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.

Code:

---

$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.

Code:

---

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.

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.

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

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

Quote:

---

Originally Posted by boxxertrumps

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

---

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

This is what for loops are for:

Code:

---

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

---

Shouldn't it be:

Code:

---

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

---

Seeings it returns an array?

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

I often use:

Code:

---

$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.

Quote:

---

Originally Posted by mburt

Shouldn't it be:

Code:

---

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!

Haha, whoops -- I think it should have been

Code:

---

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

---

I didn't really look, just inserted code around what was already there :)

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

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

Like this:

Code:

---

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

---

thanks twey and everyone else!! works great!