UNION ALL does not echo out additional text

Question

This is my code:

<?php
$stmt = $pdo->prepare("
    SELECT valueA, 'TEXT' AS valueAA FROM tableA
    UNION ALL
    SELECT valueB, 'TEXT2' FROM tableB;
");
$stmt->execute();
$points = $stmt->fetchAll();

foreach($rows as $row):
$valueA = htmlentities($row['valueA']);
$valueAVAR = number_format($valueA);
?>
<div><?php echo $valueAA . $valueAVAR; ?></div>
<?php endforeach; ?>

This is the unwanted result I am getting:

valueA
valueB

This is the result I want:

TEXTvalueA
TEXT2valueB

So basically, my code is not echoing out the word TEXT before valueA and valueB as it should based on my SQL statement. Can you please help me rewrite my code so TEXT can get echoed out? Thank you

EDIT: Sample of tableA:

valAid (int11) | valueA (int11)
  1            | 100

tableB:

valBid (int11) | valueB (int11)
  2            | 200

Answer 1

I was in the process of writing this and saw Tim's comment, which is exactly what I was going to say. It seems much easier to add the string "TEXT" to the information you want in the PHP instead of the SQL. Here is an example:

echo "TEXT" . $valueAA . $valueAVAR;

Answer 2

If you want a SELECT UNION to work then you'll need to ensure that the column names (aliases) are the same for both rows.

So instead of:

SELECT valueA, 'TEXT' AS valueAA FROM tableA
UNION ALL
SELECT valueB, 'TEXT' FROM tableB;

Would this give you closer to what you want?

SELECT valueA AS valFirst, 'TEXT' AS valSecond FROM tableA
UNION ALL
SELECT valueB AS valFirst, 'TEXT' AS valSecond FROM tableB;

Answer 3

You never read your field valueAA from your query.

<?php
...
foreach($rows as $row):
$valueA = htmlentities($row['valueA']);
$valueAVAR = number_format($valueA);
# read valueAA
$valueAA = htmlentities($row['valueAA']);
...
?>
<div><?php echo $valueAA . $valueAVAR; ?></div>