help with php + mysql

[Youko]

So, I don't really know how to achieve this with php, so any help would be much appriciated. I bet this is so simple of a solution, I'll look like an idiot.  :-\

 

So.

 

I have 2 MySQL tables.

 

I wan't to take an value from a cell on table 1, substract that from a cell from table 2 so that the new value saves to the cell on table 2.

 

Like: money - item_price = this much money

 

Thank's in advance!

[farkewie]

you can give this a go..

 

 

<?php

$cost = (($table1_row['price']) - ($table2_row['price']));

echo $cost;



?>

 

you will have to do your querys fisrt and change the code to suit your variable in the querys.

[Youko]

Thanks for the quick reply! The problem is I don't know how to do so. Also, instead of just printing the aammount left, I'd want it to be inserted back to the money cell.

[farkewie]

Go here and take a look get some code going when you start getting errors try google or searching this site. then post again if need be.

 

http://www.php.net/manual/en/ref.mysql.php