Adding string variable

[ZOR]

How do I do this?

//$query = "SELECT Orderdate,Ordernumber, Description, Caption FROM Orders ORDER BY `orders`.`ID` ASC , `orders`.`OrderNumber` ASC;";

Trying to reduce the length of the codeline. I tried & and + but does not like it? Thanks

$query = "SELECT Orderdate,Ordernumber, ";
$query = $query + "Description, Caption FROM Orders ORDER BY `orders`.`ID` ASC , `orders`.`OrderNumber` ASC;";

 

[ZOR]

Solved thanks:
$queryA = "SELECT Orderdate,Ordernumber, ";
$queryB = "Description, Caption FROM Orders ORDER BY `orders`.`ID` ASC , `orders`.`OrderNumber` ASC;";
$query=$queryA.$queryB;

 

[Vragabond]

A simpler and cleaner solution would be:

$query  = "SELECT Orderdate,Ordernumber, ";
$query .= "Description, Caption  FROM Orders ORDER BY `orders`.`ID` ASC , `orders`.`OrderNumber` ASC;";