PHP, MySQL, and temporary tables
Posted
by dave
on Stack Overflow
See other posts from Stack Overflow
or by dave
Published on 2010-04-13T05:04:38Z
Indexed on
2010/04/13
5:12 UTC
Read the original article
Hit count: 467
Php novice.
1.Is there anything wrong with this PHP & MySQL 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 () ) ;
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)?
© Stack Overflow or respective owner