[SOLVED] output empty values

[Shamrox]

Ok, I just can't get it. Maybe having an early morning brain freeze. what's missing here? My output is empty values.

[code]
$strQuery = "SELECT vendorname, sum(cogs) as sumcogs FROM spec_registrar WHERE orderdate>='2006-01-01' GROUP BY vendorname HAVING sumcogs>=15000";
   $result = mysql_query($strQuery) or die(mysql_error());
   $row = mysql_fetch_array($result);
   $rowcount = mysql_num_rows($result);
    while ($ors = mysql_fetch_row($result)) {
    $strXML .= "<set label='" . $ors['vendorname'] . "' value='" . $ors['sumcogs'] . "' />";
      }
mysql_free_result($result);
[/code]

[wildteen88]

mysql_fetch_row doesnt return an associative array. Only a numerical array. Change mysql_fetch_row to mysql_fetch_assoc instead:
[code]$strQuery = "SELECT vendorname, sum(cogs) as sumcogs FROM spec_registrar WHERE orderdate>='2006-01-01' GROUP BY vendorname HAVING sumcogs>=15000";

$result = mysql_query($strQuery) or die(mysql_error());

while ($ors = mysql_fetch_assoc($result))
{
    $strXML .= "<set label='" . $ors['vendorname'] . "' value='" . $ors['sumcogs'] . "' />";
}

mysql_free_result($result);[/code]

[Shamrox]

YES, you rule!!!! Gold star for wildteen88.

thanks.