Setting a maximum in an Integer Field

[markvaughn2006]

Is there a way to set a maximum number in a field that is an integer??

example - Field name is Energy, every 15 minutes 1 is added to Energy until 100 is reached.

Thanks for any help!!

[khr2003]

is 1 added to the database? then make a query and check the number.

 

$query = mysql_query("Select * from tablename");

$row = mysql_fetch_row($query);

 

if($row['energy'] == 100)

{

echo "We have reached the maximum entry allowed";

}