how to connect an iphone application to mysql database

iOS supports SQLite, not MySQL.  If you decide to work with SQLite, here's a tutorial:  http://dblog.com.au/iphone-development-tutorials/iphone-sdk-tutorial-reading-data-from-a-sqlite-database/

Is it possible to installl Mysql on IPhone? That would suprise me. But anyway if one can install MySQL than the c libraries  should be unproblmatic too. And that is documented in:
http://dev.mysql.com/doc/refman/5.0/en/c.html

But I guess the question is how to connect to Mysql on some Server and for that the above should hold also...

As so far i looked, iphone can use only SQLite that comes with iphone. no other database  can be connected. correct me if i am wrong. it seems not right as Android is welcoming all technologies. There are some 3rd party clients available for iphone like Flipper and iMy but i don't think if they can help to wok with iphone app ? Can we import some class to work with it ?

Do you want to be able to get the database from the Internet or store it in a file in the resources folder of your iOS application?

1. we have to link to mysql server , that have database set for this project. So ,yes access type is internet.
2. A web app. will be use to add,edit,update,delete data in database.
3. iSO app. will show data from database. A list of massages title with thumbnails will show on 1st view, when click it will goto next view to show details of clicked 'message title' or 'thumbnail'.

Now problem is do we need to add some client library for mysql as part of app or on iphone to make it connect to server so that is can update list .

codeflux has posted a good example but it is for SQLite that is local database and is limited in nature.

2nd approach i am thinking that if we create the RSS feed url from mySql database then we can use this RSS url to show data in ISo app.

What are the possibilities ..?

Thanks SpeedyApocalypse, i will try it and then let you know.