perform multiple MySQL queries with one web service iOS

Vote count:

0

I am new to the iOS development side of things and even newer to the development of APIs and WebServices.

Im having trouble with having my iOS app connect to a web service and then list all files related specifically to the user.

The problem I am having results mainly form the fact that the user data is related via 3 different tables. For example: 'ID' field in users table relates to 'customer' field in properties table which then relates to 'visible' field in the reports table. So essentially I need to run a query that takes the $_SESSION variables from my web service login script (Already created and working) and performs the queries I need to get the list of reports so I can populate a UITableView in my iOS app.

NOW……….Thats where I fall down. I actually don't have a clue what the best way to do this is. Can this be done in a single script and still have the results encoded as JSON and returned to the API? Or does there have to be multiple calls from the API once each data set is received?

Can you point me to any tutorials or info relating to this type of structure?

Obviously I am happy to do the reading and learn these techniques for myself, but I have been looking for 2 days and I haven't found what i need.

any help would be great.

asked 2 mins ago

Djinné22

5