[thelist] PHP & mySQL select error - whitespace issue?

[Burhan Khalid]

Tom Dell'Aringa wrote:

> --- Anthony Baratta <anthony at baratta.com> wrote:
> 
>>I don't normally daisy chain SQL Statements. I would recommend
>>breaking 
>>them up into distinct statements and running each seperately.
> 
> 
> Funny you mention that, when I broke it up into just one it seems to
> work. I can't understand why you can daisy them within mySQL but not
> in php? Seems rather odd. Makes more work for me...oh well.
> 
> ANyone know how to successfully daisy chain them?

The problem here is that mysql_query() will not execute queries that end 
in a semicolon (I believe for security reasons).

<quote ref="http://www.php.net/mysql_query">
Note:  The query string should not end with a semicolon.
</quote>

So, your only choice is to execute separate statements.