I am attempting to connect to a view in my sqlite database, but it is failing. I can't seem to find any information on internet to resolve.
I am using the php pdo textbook approach to make my request with SQL -
$con->prepare("SELECT * FROM view")
Query fails. Is there a method to specifically connect to the view, which is different from a table?