I want to create a BlackBerry app for OS 4.7 that connects to a remote MySQL database and fetches all rows from a table and displays them in the app.
I searched and some say that I can use PHP as a middleware for the app on the device to talk to instead of directly accessing the database.
You probably have that database on a server. You cannot access the database directly from the application on your device. Instead you can build a web service that accesses that database and returns the information to the application in a easy to parse format(xml/json). The application would then access the web service and parse the response it returns.