Trying to merge 2 queries using UNION

[shmideo]

The queries merge ok and results are correct except I get a notice: "Notice: Use of undefined constant UNION - assumed 'UNION' in...."

But is UNION a constant or is the context wrong?

$query = $query1." ".UNION." ".$query2;

$result = mysqli_query($dbcon, $query) or die('Error getting data');
$num_rows = mysqli_num_rows($result);

[Barand]

Your syntax is wrong. UNION should be inside the quotes otherwise PHP assumes it is defined constant. When it then finds no definition then it assumes (correctly) that it meant to be a string value.

 

$query = $query1 . " UNION " . $query2;

[shmideo]

Thank you so much Barand.