basic-php-04-alter-movie.php / php
<?php //alter "movie" table to include running time/cost/takings fields add = "ALTER TABLE movie ADD COLUMN ( " . "movie_running_time int NULL, " . "movie_cost int NULL, " . "movie_takings int NULL)"; add) or die(mysql_error()); //insert new data into "movie" table for each movie results = mysql_query(update = "UPDATE movie SET " . "movie_running_time=90, " . "movie_cost=3, " . "movie_takings=90 " . "WHERE movie_id = 2"; update) or die(mysql_error()); results = mysql_query(
(C) Æliens 20/2/2008
You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.