As far as I'm aware, in php you can only do one statement per call.
Terry
--Original Message-
> Hi there,
>
> When i try to do the following in PHP I get errors. Is this not
> permitted or is this due to a setting somewhere? Can i do only one SQL
> statement per call to mysq
"Edison Cneeden" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> When i try to do the following in PHP I get errors. Is this not permitted or
> is this due to a setting somewhere? Can i do only one SQL statement per call
> to mysql_query?
Yes.
>
> $sql = "CREATE TEMPORARY TABLE tmp
> SELECT field1
Hi there,
When i try to do the following in PHP I get errors. Is this not permitted or
is this due to a setting somewhere? Can i do only one SQL statement per call
to mysql_query?
$sql = "CREATE TEMPORARY TABLE tmp
SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1';
INSE
