Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = "UPDATE products
- SET products_reference='$varenummer', products_price='$pris'
- WHERE products_id='$id';";
- for ($x = 1; $x <= $amountOfLanguages; $x++) {
- $varenavn = $_POST["varenavn-" . $x];
- $korttekst = $_POST["korttekst-" . $x];
- $langtekst = $_POST["langtekst-" . $x];
- $query .= "IF EXISTS (SELECT * FROM products_description WHERE products_id='$id' AND languages_id='$x')
- UPDATE products_description
- SET products_description_name='$varenavn', products_description_short_description='$korttekst', products_description_description='$langtekst'
- WHERE products_id='$id'
- AND languages_id='$x'
- ELSE
- INSERT INTO products_description (products_id, languages_id, products_description_name, products_description_short_description, products_description_description)
- VALUES ('$id', '$x', '$varenavn', '$korttekst', '$langtekst');";
- }
- if ($conn->multi_query($query) === TRUE) {
- //header("Location: ./");
- //die();
- echo "done";
- } else {
- echo "Error: " . $query . "<br>" . $conn->error;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement