Help printing error message...

[bccron]

I am uppdating a mysql database from a webpage, with this piece of code:

if ( isset( $reglerna2 ) )
{
$query = \"UPDATE biljett0 SET antal = antal - $number\";
$result = mysql_query( $query );
if ( ! $result )
die (\"Error\");
}

But how do I print an error message if the value from $reglerna2 (input from webpage) ecceeds the databas value (antal) ??

[Anon]

Do a SELECT before the UPDATE to see what antal is...

Diego

[bccron]

Thanks...

$get = mysql_query( "select * from biljett0" );
$antal=mysql_result($get,"antal");

if ( $reglerna2 > $antal )
{
print "There is not so much left";
exit;
}
elseif ( $antal < 1 )
{
print "There is nothing left " ;
exit;
}