Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. $sql = mysql_query("UPDATE film SET (`name`,`release`,`runtime`,`rating`, `description`,`price`) VALUES ('$name','$release','$runtime','$rating','$des','$price' WHERE film_id ='$fid')") or die (mysql_error());
  2.  
  3. $fid = $row['film_id'];
  4. $name = mysql_real_escape_string($_POST['name']);
  5. $release = ($_POST['release']);
  6. $runtime = ($_POST['runtime']);
  7. $release = $row['release'];
  8. $rating = $row['rating'];
  9. $runtime = $row['runtime'];
  10. $des = $row['description'];
  11. $price = $row['price'];
  12.  
  13. UPDATE `film`
  14. SET `name` = '$name',
  15. `release` = '$release',
  16. `runtime` = '$runtime',
  17. `rating` = '$rating',
  18. `description` = '$des',
  19. `price` = '$price'
  20. WHERE `film_id` = '$fid'
  21.  
  22. $sql = mysql_query("UPDATE film SET name='$name',release='$release,runtime='$runtime',rating='$rating',description='$description' where film_id = '$id'");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement