Re: MySQL Equations

[Nick Roper]

Hi David,

Assuming that you have the number of points stored in a variable (say $points) and cust_id is a unique index on the customers table then it would be something like :


<?php

# other code here

.....

# points stored in $points

$sql = "UPDATE customers SET cust_points = cust_points + $points WHERE cust_id = '$cust_id' ";

$result = mysql_query($sql) or die (mysql_error()) ;

......

?>

--
Nick Roper