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
