CREATE question

From: Date: Thu, 30 Oct 2008 19:19:12 +0000
Subject: CREATE question
Groups: php.general 
Request: Send a blank email to php-general+get-282646@lists.php.net to get a copy of this message
All, Is it possible for us to use PHP to create temp tables in our database? Ironically, up until this point I have only needed to use SELECT statements. But now, to speed up the processing time of a large query I would like to create a temp table and then reference the temp table in another query. I've tried stuff like the below: $temp_query = "create temp table my_temp_table( date date, code char(3), loc char(3), time DATETIME HOUR TO MINUTE, matter_id int, name char(25) ) WITH NO LOG"; $do_query = ifx_query($temp_query, $connect_id); But all that does is give me an "ifx_prepare fails" message. Can we not use the ifx_query, mssql_query, mysql_query functions to create tables? Can they only be used to select data? Thanks in advance, Dan

« previous php.general (#282646) next »