MySql Query Length

[kazer]

I'm attempting to run a query against my database and the query itself is quite long. I could span it across multiple lines if I was at the console, how would I go about doing that with PHP? Is there another function for longer queries, or a function for submitting queries in sections?

any help would be greatly appreciated.

-Kaz

[sfullman]

very simple, just hit enter!

$sql = "
select
this as that,
those as them

from

complextable1 as something,
complextable2 as otherthing,

..

Where

very complex condition

";

Nothing more to it; both PHP and mySQL will ignore the newline characters.

NOTE: I always use double quotes to enclose the string, that way I can use $variables and have them recognized.

Sam