title: PHP, MySQL, and temporary tables
body: <p>Php novice.</p>
  
  <p>1.Is there anything wrong with this PHP &amp; MySQL code?</p>
  
  <pre><code>include_once "db_login.php" ;
  
  $sql = "DROP TEMPORARY TABLE IF EXISTS temp_sap_id_select" ;
  mysql_query ( $sql ) or ( "Error " . mysql_error () ) ;
  
  $sql = " CREATE TEMPORARY TABLE temp_sap_id_select 
                 (
                   `current_page` INT NOT NULL,
                   `total_pages` INT NOT NULL,
                   `select_date` DATE NOT NULL,
                   `select_schcode` CHAR(6) NOT NULL,
                   `select_user` CHAR(30) NOT NULL,
                   `select_id` CHAR(9) NOT NULL
                 ) " ;
  mysql_query ( $sql ) or ( "Error " . mysql_error () ) ;
  </code></pre>
  
  <p>2.Admittedly, I'm a dull boy, but I'll ask anyway: If I'm using a MySQL GUI and have open the target database, will it be aware of the above temporary table created by PHP/MySQL (IF the temporary table is properly created)?</p>