running long queries?

[eluser]superfake123[/eluser]
Hello, How do you run long queries? I keep getting "A Database Error Occurred" with the following code: http://pastebin.com/bAtT2x65

thanks...

[eluser]CroNiX[/eluser]
I don't think that's the problem. I'm pretty sure you can only have 1 sql statement per query. Try breaking your CREATE TABLE and INSERT statements into two separate strings and execute/query them separately.

[eluser]Abel A.[/eluser]
Actually that query is not big at all. What CroNiX said is correct, you can't run 2 queries via the php driver.

[eluser]superfake123[/eluser]
separating them worked, thanks guys!