Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 1400 | Replies: 4
![]() |
Hi All
I need help and i am new to php so bare wih me
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:
Problem here is that it is not adding all the rows together and then getitng the price but instead its just avraging 1 row.
I need help and i am new to php so bare wih me
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.
•
•
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 344
Reputation:
Rep Power: 4
Solved Threads: 4
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:
[PHP]
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>"; [/PHP]
See if this does not show you where the problem is. Let us know.
[PHP]
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>"; [/PHP]
See if this does not show you where the problem is. Let us know.
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.
______________________________________________
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.
•
•
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 344
Reputation:
Rep Power: 4
Solved Threads: 4
AHA!!! Remove the semicolon at the end of this line:
[PHP]
for ($i=0;$i<$nrow;$i++);
[/PHP]
[PHP]
for ($i=0;$i<$nrow;$i++);
[/PHP]
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)





Linear Mode