<?php
$server = "localhost";
$dbuser = "****";
$dbpass = "*****";
$dbname = "umafia";
mysql_connect($server,$dbuser,$dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$respekt = rand (1,3);
$money = rand(10,60);
$crime = rand(1,2);
if ($crime == "1") {
echo "En mann kommer å legger $money Kr i koppen din";
mysql_query("UPDATE `members` SET `your_money` = `your_money` + '$money' WHERE `id` = '1'") or die(mysql_error());
mysql_query("UPDATE `members` SET `Respekt` = `Respekt` + '$respekt' WHERE `id` = '1'") or die(mysql_error());
}
elseif ($crime == "2"){
echo "Folk bare går forbi deg og spytter på deg!";
mysql_query("UPDATE `members` SET `Respekt` = `Respekt` - '$respekt' WHERE `id` = '1'") or die(mysql_error());
}
?>
how do i make this:
mysql_query("UPDATE members SET Respekt = Respekt - '$respekt' WHERE id = '1'") or die(mysql_error());
stop when its only "1" on the 'respekt'-field??
