PHP fetch pdo with hyphen in column name

Question

So I'm writing a php project and I got stuck on hyphens in column names of a table in a database. I have the following code:

 $results = $conn->query($sql)->fetchAll(PDO::FETCH_OBJ);
     foreach ($results as $row) { ?>
      <tr>
        <td><a href="#<?= $row->factuur-status ?>"><?= $row->factuur-status ?></a></td>
        <td><?= $row->verkoop-orderid ?></td>
      </tr>
<?php } ?>

Now obviously because of the hyphens in the column names this doesn't work. How can one fix this?

I can't use those (``) in the code I have written. I already tried that... — Ken, Jan 04 '14 at 00:00

score 1 · Answer 1 · answered Jan 04 '14 at 00:19

1

I found it, if someone's interested:

<?= $row->{'factuur-status'} ?>

answered Jan 04 '14 at 00:19

Ken

2,859
4
24
26

PHP fetch pdo with hyphen in column name

1 Answers1