MySQL query fail in CI and PHP but not with MySQL client

[eluser]Unknown[/eluser]
Hello obiron2,

Thanks for replying.

put quotes round your SQL string, otherwise PHP sees the first semicolon and thinks it is the end of the PHP command.

I've already done that. And put also the sql statement on one line.

I don't want to use procedures because of portability.

Also, I think you have a misunderstanding about the way MySQL use temporary table.

Temporary tables differ from normal tables in that temporary tables exist only
for the duration of the current session and are automatically deleted after it ends.
(For web applications, this means that temporary tables generally cease to exist
upon completion of the current page or script.)

http://dev.mysql.com/tech-resources/arti...n-ch5.html (p264 of the referred PDF)

And...

A MySQL temporary table can have any legal name, even the same name as an existing regular table. In this case it will mask the regular table.

http://www.xaprb.com/blog/2006/03/26/tem...-in-mysql/

Cheers
-Emmanuel