topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

basic-php-04-alter-movie.php / php



  <?php
  link = mysql_connect("localhost","bp5am","bp5ampass") 
    or die(mysql_error());
  mysql_select_db("moviesite") 
    or die (mysql_error());
  
  //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)";
  results = mysql_query(add)
    or die(mysql_error());
  
  //insert new data into "movie" table for each movie
  update = "UPDATE movie SET " .
            "movie_running_time=102, " .
            "movie_cost=10, " .
            "movie_takings=15 " .
            "WHERE movie_id = 1";
  results = mysql_query(update)
    or die(mysql_error());
  
  update = "UPDATE movie SET " .
            "movie_running_time=90, " .
            "movie_cost=3, " .
            "movie_takings=90 " .
            "WHERE movie_id = 2";
  results = mysql_query(update)
    or die(mysql_error());
  
  update = "UPDATE movie SET " .
            "movie_running_time=134, " .
            "movie_cost=15, " .
            "movie_takings=10 " .
            "WHERE movie_id = 3";
  results = mysql_query(update)
    or die(mysql_error());
  
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(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.