Get a single return value using PDO

Question

For this request: $sql='select col from table where other_col=?';

I am currently receiving the returned data as follows: $data=$statement->fetch()['col'];

This is not very good for me. Is there a better way to do this or is it perfect as it is?

+5

Francisc Jun 27 '12 at 11:14

1 answer

caRameL · Accepted Answer · 2012-06-27T11:16:40+0000

You can try:

$data=$statement->fetchColumn(0);