calculating columns &amp; rows.

calculating columns & rows.

Anon

This forum is my lifesaver. new problem.

my r_date table has this structure:

id | request | pdate |

1 10 2001-11-12 |
2 5 2001-11-10 |
1 5 2001-11-10 |
- - - - - - - - - - - - - - |

now, how can i calculate the total for those items whose id=1 in this case the total should be 15 (10+5), but what code do i need. please if possible give me the whole querry code i am not fluent enough in php yet. thank you very much.

Regards
Arman Galstyan
eNotalone.com inc.

sourcecode

$conn = mysql_connect(..);
mysql_select_db(..);
mysql_query(...);
while ($row = mysql_fetch_row(...)) {
if ($row["id"] == 1)
$sum += $row["request"];
}
echo "total sum: $sum<br>";

tip: you shouldn't depend on the others to program, get yourself a php book and start to cook... 😛

Anon

You can get the total of requested items by a sql query, instead of a loop in php, like this:

$@!#$ = mysql_query("select sum(request) as total from r_date group by id");
while($pf = mysql_fetch_array($@!#$)) {
...
}

www.mysql.com and www.php.net are great resources.

enotalone wrote:

This forum is my lifesaver. new problem.

my r_date table has this structure:

id | request | pdate |

1 10 2001-11-12 |
2 5 2001-11-10 |
1 5 2001-11-10 |
- - - - - - - - - - - - - - |

Regards
Arman Galstyan
eNotalone.com inc.

Anon

The other (quicker, i suppose) way is to use SQL function SUM :

$result = mysql_query("
SELECT SUM(request) FROM the_table WHERE id=1
",$database);

Fortune cookie: Read the Manual! ;-)

Anon

Great, thank you very much Leonardo. works just fine and exactly what i wanted. many thanks. arman

Anon

Oops, i'm late...

Anon

Guys i've confused you. here is my code. now, i need to calculate how many ex. apples do i have all togther & gow many cars etc.

table is like this:
pid request pdate
1 5 somedate
1 5 somedate
2 3 somedate
2 2 somedate

now, i need to know how many request i have in total for $pid=1, $pid2 and the rest. so the result somehow should be:
1=10
2=5 etc. for the rest of the table. how to do this with my code? please help and thank you all.

while ($result=mysql_fetch_array($query)) {

$lineIndex++;

$pid=$result['pid'];
$phrase=$result['phrase'];
$request=$result['phrase'];

}