<?php // modyfikacja tabeli movie w celu dodania pól czasu trwania, kosztów i zysku $add = "ALTER TABLE movie ADD COLUMN ( " . "movie_running_time int NULL, " . "movie_cost int NULL, " . "movie_takings int NULL)"; // wstawianie nowych danych do tabeli movie dla każdego filmu $update = "UPDATE movie SET " . "movie_running_time=102, " . "movie_cost=10, " . "movie_takings=15 " . "WHERE movie_id = 1"; $update = "UPDATE movie SET " . "movie_running_time=90, " . "movie_cost=3, " . "movie_takings=90 " . "WHERE movie_id = 2"; $update = "UPDATE movie SET " . "movie_runnig_time=134, " . "movie_cost=15, " . "movie_takings=10 " . "WHERE movie_id = 3"; ?>