Ad:

PHP Discussion Thread
Unsolved
Views: 1821

Jun 29th, 2005

HELP PHP w/SQL Code HELP

Expand Post »

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:

PHP Syntax (Toggle Plain Text)
$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>";
$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.

Similar Threads

Problem with php and SQL in PHP
how to do conenction between php and my sql in PHP
changing my php sql code to oracle in MySQL
PHP/SQL query help in PHP
Saving Code in PHP in MySQL

ashneet

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

147 posts
since Jun 2005

Permalink

Jun 29th, 2005

Re: HELP PHP w/SQL Code HELP

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

extract ($row);
echo " VH4: ".$VH4;
echo " UD4: ".$UD4;
echo " Handling: ".$Handling;
$Total = $Total + $VH4 + $UD4 + $Handling;
echo " Total: ".$Total;
}
}
else
{
echo "LOL ";
}
echo "<hr />nrow: ".$nrow;
echo " Total: ".$Total;
$Total = $Total / $nrow;
echo " $Total "; [/PHP]
See if this does not show you where the problem is. Let us know.

Troy

Reputation Points: 36

Solved Threads: 6

Posting Whiz

Offline

354 posts
since Jun 2005

Permalink

Jun 30th, 2005

Re: HELP PHP w/SQL Code HELP

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.

ashneet

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

147 posts
since Jun 2005

Permalink

Jun 30th, 2005

Re: HELP PHP w/SQL Code HELP

AHA!!! Remove the semicolon at the end of this line:
[PHP]
for ($i=0;$i<$nrow;$i++);
[/PHP]

Troy

Reputation Points: 36

Solved Threads: 6

Posting Whiz

Offline

354 posts
since Jun 2005

Permalink

Jul 1st, 2005

Re: HELP PHP w/SQL Code HELP

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

ashneet

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

147 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Help to create a unique forum

Next Thread in PHP Forum Timeline: help on extractin from vbulletin

DaniWeb Message

Cancel Changes

User Name
Password