mysqli + update statement Opcje

[bezimienny]

Witam,
Od kilku godzin siedze nad mysqli i co krok to wiekszy problem. Mianowicie teraz mam problem z klauzula UPDATE. Moglby ktos powiedziec co robie zle? Albo moze jakis super lekki framework do mysql?

[PHP] pobierz, plaintext 
$sql = "SELECT activated FROM ssoclientsessions WHERE sessionId=?";
 
		$mysqli = mysqli_connect($this->serverName, $this->userName, $this->password, $this->dataBase);
 
		if (mysqli_connect_errno()){
			printf("Connect failed: %s \n", mysqli_connect_error());
			exit();
		}
 
		$stmt = $mysqli->stmt_init();
 
		if ($stmt->prepare($sql)){
 
			$stmt->bind_param('s', $sessionId);
			$stmt->execute();
			$stmt->bind_result($activated);
			$stmt->fetch();
 
 
				// Active session
				if (!$activated) {
 
					$dateNow = date("Y-m-d G:i:s");
 
					$sql = "UPDATE ssoclientsession SET dateactivated=?, activated=1, datechecked=? WHERE sessionid=?";
 
					if ($stmt->prepare($sql)){
 
						$stmt->bind_param('sss', $dateNow, $dateNow, $sessionId);
						$stmt->execute();
						$stmt->close();
					}	
 
					else die("Cannot prepare SQL statement: $sql");*/
		        	}
 
 
 
			$stmt->close();
		}
 
		else die("Cannot prepare SQL statement: $sql");
 
 
		$mysqli->close();
[PHP] pobierz, plaintext 

Na zdrowy rozum to powinno dzialac. Moze kwestia transakcji?

Ten post edytował bezimienny 24.06.2010, 18:23:23