Point adding

[Imtehbegginer]

<?php
  $re = mysql_query("SELECT * FROM characters");
  $row = mysql_fetch_array($re);
  $str = $row['str'];
  $con = $row['con'];
  $int = $row['_int'];
  $dex = $row['dex'];
  $lvl = $row['level'];
  ?>

 

All of them are echod into a space for the user to see there current character points.

There is a row: statp, that's how many points they have.

 

How can I make sure that the input of str, con, dex, and int dont go over the amount in the statp row?

[trq]

The answer to your question really depends on twhat it is you want to do if the sum of these values go over. Anyway, a simple example might be....

 

<?php
if (($row['str'] + $row['con'] + $row['_int'] + $row['dex']) < $row['statp']) {
  // sum less then statp
}
?>

 

You would be best however to do this with SQL but you'd need to explan more about exactly what it is you want to do.

[Imtehbegginer]

Thanks alot!