What would need to be done to add location?

JWalters
2005-01-14
2013-04-10
  • JWalters
    JWalters
    2005-01-14

    I keep my movies in CD binders.  What would need to be edited to add a book # and page # to the existing movie information?

    Although I am a programmer, this is my first attempt at PHP and mySQL.

    At the moment, I've added 'locbook' and 'locpage' entries to the "movies" table.  I'm trying to edit "filmform.php" to add the extra fields.

     
    • JWalters
      JWalters
      2005-01-14

      OK, I think I have most of the HTML-ish stuff done.  It's displaying default book and page #s from the DB.  I'm struggling with update.php and adding both values.

      I'm trying to put them in the moviequery() function.  I modeled the line off of runtime, but it doesn't work (SQL syntax error).  Any help would be appreciated.  php4flicks is great and has really helped me organize my collection.

       
    • JWalters
      JWalters
      2005-01-14

      Got it.  :)

      LMK if anyone could make use of them.  Talk about a crash course in SQL.