Problem z UPDATE w if Opcje

[Bootsyou]

Mam pewien skrypcik, który wymaga sporo if w zależności czy liczba jest większa od tego czy owego... Tak, czy inaczej MySQL z niewiadomego powodu nie chce wykonać UPDATE przy tym if'ie:

[PHP] pobierz, plaintext 
f ($is_it_there==$name AND $result>$is_it_there2 AND $result>$is_it_there3) {
		mysql_query("UPDATE highscore SET result='$result' WHERE nickname='$name'")or die("<br /><br />ERROR: Updating Highest Score failed!");
		echo "<br /><br /><b><font color='red'>Your Highest score has been updated.</font></b><br /><a href='index.php'>GO BACK</a>";
	}
[PHP] pobierz, plaintext 

Całość kodu to:

[PHP] pobierz, plaintext 
// Get values from form 
$name=$_POST['nickname'];
$result=$percent;
 
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
$choose = "SELECT nickname FROM highscore WHERE nickname='$name'";
$zap = mysql_query($choose);
$chosen = mysql_fetch_assoc($zap);
$is_it_there = $chosen['nickname'];
 
$choose2 = "SELECT result FROM highscore WHERE nickname='$name'";
$zap2 = mysql_query($choose2);
$chosen2 = mysql_fetch_assoc($zap2);
$is_it_there2 = $chosen2['result'];
 
$choose3 = "SELECT result2 FROM highscore WHERE nickname='$name'";
$zap3 = mysql_query($choose3);
$chosen3 = mysql_fetch_assoc($zap3);
$is_it_there3 = $chosen3['result2'];
 
if ($is_it_there==$name AND $result>$is_it_there2 AND $result>$is_it_there3) {
		mysql_query("UPDATE highscore SET result='$result' WHERE nickname='$name'")or die("<br /><br />ERROR: Updating Highest Score failed!");
		echo "<br /><br /><b><font color='red'>Your Highest score has been updated.</font></b><br /><a href='index.php'>GO BACK</a>";
	}
	elseif ($is_it_there==$name AND $result>$is_it_there2 AND $result<$is_it_there3) {
		mysql_query("UPDATE highscore SET result='$result' WHERE nickname='$name'")or die("<br /><br />ERROR: Updating Highest Score failed!");
		mysql_query("UPDATE highscore SET result2='$result' WHERE nickname='$name'")or die("<br /><br />ERROR: Updating Lowest Score failed!");
		echo "<br /><br /><b><font color='red'>Your Highest and Lowest score have been updated.</font></b><br /><a href='index.php'>GO BACK</a>";
	} 
	elseif ($is_it_there==$name AND $result<$is_it_there2 AND $result<$is_it_there3) {
		mysql_query("UPDATE highscore SET result2='$result' WHERE nickname='$name'")or die("<br /><br />ERROR: Updating Lowest Score failed!");
		echo "<br /><br /><b><font color='red'>Your Lowest score has been updated.</font></b><br /><a href='index.php'>GO BACK</a>";
	}
	elseif ($is_it_there==$name AND $result<$is_it_there2 AND $result>$is_it_there3) {
		echo "<br /><br /><b><font color='red'>Your Lowest or Higest score have NOT been updated. This attempt is NOT your highest/lowest.</font></b><br /><a href='index.php'>GO BACK</a>";
	}
	elseif ($is_it_there!=$name) {
	// Insert data into mysql 
	$sql="INSERT INTO $tbl_name(result, nickname, result2)VALUES('$result', '$name', '$result')";
	$result=mysql_query($sql);
 
	// if successfully insert data into database, displays message "Successful". 
	if($result){
	echo "<br /><br /><b><font color='red'>New Highscore for this nick! Score saved.</font></b><br /><a href='index.php'>GO BACK</a>";
	}
 
	else {
	echo "<br /><br /><b><font color='red'>ERROR: If you spot this error after refreshing this page please ignore. If not - report to Cromiell.</font></b>";
	}
}
[PHP] pobierz, plaintext 

[Bootsyou]

Mam bazę " result | nickname | result2 "
W tej sytuacji if chodzi o UPDATE ponieważ nick już istnieje w bazie (nie robimy nowego rekordu). Potem sprawdzamy, czy jest większy od kolumny result i result2. Warunek zostaje spełniony więc chcę wykonać UPDATE tylko na kolumnie result a result2 nie ruszać. Krótki opis jak ma zadziałać.

(IMG:http://img9.imageshack.us/img9/8594/beztytuuarc.png)

Ten post edytował Bootsyou 18.07.2012, 20:39:00