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-03-select-rev01.php / php



  <?php
  //connect to MySQL
  connect = mysql_connect("localhost", "bp5am", "bp5ampass") 
    or die("Hey loser, check your server connection.");
  
  //make sure we're using the right database
  mysql_select_db("moviesite");
  
  query = "SELECT movie_name, movie_type " .
           "FROM movie " .
           "WHERE movie_year>1990 " .
           "ORDER BY movie_type";
  results = mysql_query(query)
    or die(mysql_error());
  
  while (row = mysql_fetch_array(results)) {
    extract(row);
    echo movie_name;
    echo " - ";
    echo movie_type;
    echo "<br>";
  }
  
  ?>
[] 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.