count results?

[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?!

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!