How to add a UNION clause between two SQL statements in PHP?

Question

$sql_new=$sql1. UNION .$sql2;

This expression gives the following error notice:

Use of undefined constant UNION - assumed 'UNION' in php

Can we get some more delete votes on this question please? It is good it was solved, but I don't think it has any long-term value for future readers. — halfer, Jan 07 '18 at 14:18

score 0 · Accepted Answer · answered Jan 21 '16 at 07:18

0

$sql_new=$sql1 . " UNION " . $sql2;

you have to put your strings into quotes so that PHP knows it's a string.

answered Jan 21 '16 at 07:18

Franz Gleichmann

1 Answers1