Get the single returned value with PDO

Question

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

I am currently getting the returned data like so: $data=$statement->fetch()['col'];

That doesn't look very good to me. Is there a better way of doing that or is that fine as it is?

Answer 1

You can try :

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