[RESOLVED] Using math functions with PHP

NEX2NUN

I really never was very good with math but now I am looking to PHP to do some math functions for me.

Right now I have a database with 2 tables. This database is used for land surveying information. One table stores the land details and the second database stores the owners who own land.

I was looking to add a function to make life a little bit easier working within this database. Here's what I am currently having troubles figuring out.

I need to pull $value from the details table and add that value to the $land information from the owners table. I then need to take that new value ($value + $land) and have it multiply the new value by 3.

Here's a break down.

$value1 + $land = $new1 x 3 = $new2

Any ideas on where I can start?
Thanks in advance!

Krik

$newvalue = ($value + $land) * 3;

EDIT
Just quick explanation. It is an algebraic equation. Just like in algebra you do the part in the ( ) first then the rest.

laserlight

Actually, the calculation is simple enough to do in SQL. What are the relevant database tables and columns? What is the relationship between the tables, and your current relevant SQL statements?

NEX2NUN

Thank you, thank you! I apparently overlooked the obvious.

Here's what I was able to write up with your help and it's working like a charm.

<?php

$acresowned = $row_viewOwner['ao'];
$ditchassessment = $row_viewOwner['ast'];
$benefitassessment = $row_viewOwner['ben'];
$plotowned = $row_viewOwner['plo'];
$acrevalue = $row_viewOwner['acre'];
$minvalue = $row_viewOwner['min'];

?>

<?php

$valueao = ($acresowned + $acrevalue);

?>

<?php

$benefitvalue = ($valueao * 3);

?>

I probably need to come up with a better naming scheme but thank you again!

NEX2NUN

laserlight;10901438 wrote:
Actually, the calculation is simple enough to do in SQL. What are the relevant database tables and columns? What is the relationship between the tables, and your current relevant SQL statements?

I actually thought it might be, but I couldn't find a solution to work for that. I know my way around MySQL and PHP a bit, but no expert by any means.

But I can give it a try, do you have an example of how I could do this?

I have 2 tables (ditches) and (owners), they both share the field (number). In the ditches table is the cost per acre and in the table owners is how many acres the land owner has. Hope that makes sense.

Weedpacket

SELECT ao, acre, etc, (ao + acre) * 3 AS benefit_value FROM....

NEX2NUN

Thanks for the info, can't say I've seen that syntax before, I'll have to look it up and give it a try. Thanks again everyone! I REALLY learned a lot from this thread. It lead me to create a rather nice recordset.