Member Avatar for ashneet

Hi All
I need help and i am new to php so bare wih me :confused:
what i m tryin 2 do is that add poduct shipping handeling togther to get an avraged rate so this is the part of code Troubling me:

$nrow = mysql_num_rows($result);
if ($Vh4 == "VH4")
{
	for ($i=0;$i<$nrow;$i++);
	{
		$row = mysql_fetch_array($result);
		extract ($row);
		$Total = $Total + $VH4 + $UD4 + $Handling;
	}

}
else
{
	echo "LOL<BR><BR>";
}

$Total = $Total / $nrow; 
echo "<br>$Total<br>";

Problem here is that it is not adding all the rows together and then getitng the price but instead its just avraging 1 row.

  • 2 Contributors
  • 4 Replies
  • 283 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ashneet
Member Avatar for Troy

I do not understand how it would not be looping $nrow times. Please add echo() statements after most every line to output debugging information. For example:

if (!$result) {
  echo "<br />ERROR! result is false.";
}
$nrow = mysql_num_rows($result);
echo "<br />nrow: ".$nrow;
if ($Vh4 == "VH4")
{
  echo "<br />Starting loop";
  for ($i=0;$i<$nrow;$i++);
  {
    echo "<hr />i: ".$i;
    $row = mysql_fetch_array($result);
    if (!$row) {
      echo "<br />ERROR! row is false.";
    }

    extract ($row);
    echo "<br />VH4: ".$VH4;
    echo "<br />UD4: ".$UD4;
    echo "<br />Handling: ".$Handling;
    $Total = $Total + $VH4 + $UD4 + $Handling;
    echo "<br />Total: ".$Total;
  }
}
else
{
  echo "LOL<BR><BR>";
}
echo "<hr />nrow: ".$nrow;
echo "<br />Total: ".$Total;
$Total = $Total / $nrow;
echo "<br>$Total<br>";

See if this does not show you where the problem is. Let us know.

Member Avatar for ashneet

Hi I tried it and it didn't work here is the results
______________________________________________
nrow: 2
Starting loop
--------------------------------------------------------------------------
i: 2
VH4: 100.00
UD4: 103.00
Handling: 25.00
Total: 228
--------------------------------------------------------------------------
nrow: 2
Total: 228
114
_______________________________________________

As you see the second part should have been reped 2 time with different figures.
so now i am comfused about why it is not looping.

Member Avatar for Troy

AHA!!! Remove the semicolon at the end of this line:

for ($i=0;$i<$nrow;$i++);
Member Avatar for ashneet

Thanks that helped a lot and because of this hint i was able to expand the program even more...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.