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

Reply via email to