LampPi

Code
MySQL: UPDATE


...

# Update code row

if ((! $error) & ($action == "update_code")) {

	# Update code (lp_code table)

	$SQL = "UPDATE lp_code ";

	$SQL .= "SET ";	  

	$SQL .= "lp_code_order = '" . $new_lp_code_order . "', ";

	$SQL .= "lp_code_title = '" . $new_lp_code_title . "', ";

	$SQL .= "lp_code_desc = '" . $new_lp_code_desc . "', ";

	$SQL .= "lp_code_image = '" . $new_lp_code_image . "' ";

	$SQL .= "WHERE lp_code_id = '" . $codeRowID . "'; ";

	$result = $mysqli_link->query($SQL);



	# Any errors?

	if ($mysqli_link->error) {

		# DB error

		$error = "Database error: " . $mysqli_link->error;

	}

}

...
About
Contact
Links
Site Map