new in this area

sujon · #1 13-Sep-2003, 15:13

CAN ANY ONE HELP ME??
I'M PRETTY NEW IN PHP MYSQL I HAVE ONE TABLE AND IN THE TABLE
HAVE 5 COLUMN I WANT TO COUNT THE VALUE OF 4 COLUMN AND THAT WILL
SHOW IN ANOTHER COLUMN JAST LIKE THIS :

-----------------------------------------
-------ROW1 | R2| R3| R4 | R5-----------
-----------------------------------------
----------1 | 1 | 1 | 1 = 4 < COL1 TOTAL
-----------------------------
----------2 | 2 | 2 | 2 = 8 < COL2 TOTAL
-----------------------------------------
-----------------------------------------
----------3 | 3 | 3 | 3 | 12 < ROW TOTAL

PLEASE HELP ME
BEST REGURDS

conkermaniac · #2 13-Sep-2003, 23:03

Hi sujon,

Would you be looking for something like this?

PHP Code:


$result = mysql_query("SELECT r1,r2,r3,r4 FROM table1");
while ($row = mysql_fetch_array($result)) {
  $r5 = $r1 + $r2 + $r3 + $r4;
  mysql_query("INSERT INTO table1 (r5) VALUES ('$r5')");
}

That should work, but I might have done something wrong there...perhaps someone better at this stuff can check it for me.

JdS · #3 14-Sep-2003, 05:46

Hello sujon,

There are 2 schools of thought on this; there are those that 'work-the-script (PHP)' and then there are those that 'work-the-db (MySQL)'.

I prefer the latter... i.e. I prefer to get MySQL to do the dirty work if it can and if it's appropriate for the rest of the script.

Conkermaniac's example is a sample of the 'work-the-script'-type solution.

Here's one that's 'working-the-db':

PHP Code:


<?php
// I assume the data is off a form?
$d1 = intval( $_POST['d1'] );
$d2 = intval( $_POST['d2'] );
$d3 = intval( $_POST['d3'] );
$d4 = intval( $_POST['d4'] );

// I assume you want to insert these 'data' ($d1..$d4) into the db table...
// `r5` is the field where the total of the other 4 cols are 

$sql = "INSERT INTO `table1`
       ( `r1`, `r2`, `r3`, `r4`, `r5` )
       VALUES
       ( $d1, $d2, $d3, $d4, `r1`+`r2`+`r3`+`r4` )";    
?>

misunderstood · #4 03-Oct-2003, 06:09

Can further calculations be carried out by using this method ?

In the example

PHP Code:


<?php
Blah Blah...
$sql = "INSERT INTO `table1`
       ( `r1`, `r2`, `r3`, `r4`, `r5` )
       VALUES
       ( $d1, $d2, $d3, $d4, `r1`+`r2`+`r3`+`r4` )";    
?>

Can I add r1 + r2 + r3 then divide by r4 ?
I have tried a number of different ways to get that to work but to no avail. :-(
But as usual I will probably be missing a simple piece of code.

JdS · #5 03-Oct-2003, 12:03

Yes it's possible... but you know SQL, one typo in the statement and all hell breaks lose!

misunderstood · #6 03-Oct-2003, 12:09

Would I bracket the seperate instructions ie

PHP Code:


( $d1, $d2, $d3, $d4, (`r1`+`r2`+`r3`)/(`r4`) )";

or

PHP Code:


( $d1, $d2, $d3, $d4, `(`r1`+`r2`+`r3`)`/`(`r4`)` )";

Or am I still in the wrong direction?

JdS · #7 03-Oct-2003, 12:41

The INSERT statement I can suggest (considering everything is set up OK with your table) is:

PHP Code:


<?php

$sql = 'INSERT INTO `sometable`
       ( `r1`, `r2`, `r3`, `r4`, `r5` )
       VALUES
       ( '.$d1.', '.$d2.', '.$d3.', '.$d4.', ((`r1`+`r2`+`r3`)/`r4`) )';
?>

sujon · #8 03-Oct-2003, 12:43

hi thanx every one its working fine

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What Search Engines are you listed in?	NetWay	Search Engine Optimization Forum	6	23-Sep-2003 09:53

new in this area

10q every one