Excel or Database Lookup for Website

[joeiow]

Hi, not sure if i should have this here or in iPhone,

Basically what i am trying to do is create a system where i can have a excel document or a database online with data such as booking codes and seat numbers. Then have a website front end where the user can enter their booking code and it shows them where there seat is.

Then preferably allowing this to work on iPhones and mobile devices?

Any help, suggestions or points in the right direction are greatly appreciated!


Joe.

[angelwatt]

iPhone apps generally use SQLite to store data. I'd look there. PHP can access SQLite as well. Interfacing with an Excel document is less than ideal, though a CSV file would be manageable if necessary. Depending how much data is involved you could just do it in JavaScript and hard code the data into variables.