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

© LampPi 2024