New To jQuery and Mobile App Dev. Need Recommendations
I want to build a car parts interchange app. Basically I want the app to allow the user to select three fields from drop down menues: year, model, and part, then perform the search against a database and then I want it to return "This part is interchangeable with: (list all of the cars the part interchanges with).
What I need to know is:
1. Is this possible to use drop down menus for search queries against a dataase?
2. Is it possible to have it so that the app database is stored locally on the mobile device?
3. Would SQLite be the database platform?
4. Can this be built in jQuery?
I just need information to point me in the right direction so I can get started.