I have buztouch down pretty well. And by the way, AMAZING work being done on this site. My company has an online applications guide (http://www.vizualogicperfectapp.com) and I need to some how implement this guide into my app. Making it mobile friendly. I'm aware I can just link to the site in the app but does not work well at all in a mobile environment. I have access to the 22k line item'd Excel sheet this application guide feeds from. Need some direction here guys...trying to make my app as legit as possible.

Hi Aaaron636r: Cool site, I dig the headrests ;-) I can imagine all sorts of ways to do this - some easier than others. I think ideally it makes sense that I (the user) would be able to tap the brand of my car then continue drilling down into the options as you have it now with the drop-down lists. Mobile users will appreciate the simplicty of this approach. Something like... Menu 1: Image buttons with manufactures leads to... Menu 2: Make leadst to... Menu 3: Model leads to... Menu 4: Year... etc etc. When I'm done (that should be super quick) the app would make a backend request to your server to fetch the appropriate results, return a webpage, whatever. So, I think you'll agree that this plan would be nice but I fear that it's too difficult too pull off with your skill level? Just guessing? However, if I'm wrong, and you understand all this data stuff...dump the contents of your Excel spreadsheet into a database (like mySQL) on your backend and write up a .php script to output the results when the request was made. The menu screens would also be created dynamically from your backend. Each screen would use the dataURL property to point to your cool .php script that build the menu data. Example: The manufactures screen would request a .php script on your server that output the list of manufactures from your mySQL database, models, same thing, etc, etc. Not sure what's best for you but you could go a long way with this to make it super-pro ;-)

It is above my level. However, I don't tend to give up on things I don't know. May take me a while to get the grasp of it...but usually can with the right directions. I actually threw my excel sheet into a mySQL database to start learning the ropes yesterday. Yes...very confused at this point. But hoping to catch on eventually. Really appreciate your help David. You seem to be the man on this forum. People need to thank guys like yourself often. Not many knowing guys out there easily ready to help us small guys. :)

All good. The mySQL thing will become much clearer after a few hours in the 'admin panel' Open your phpMyAdmin control panel, I'm sure you have it on whatever server you're working with. Two core conceptes with databases (at the most basic level) a) Databases use TABLES to organize data. Each TABLE is like a spreadsheet, imagine each TABLE as individual spreadsheet. Rows and columns. Easy enough. Use the phpMyAdmin tool to create the TABLES (spreadsheets) and add FIELDS instead of column headers like in excel. So, a FIELD in table is like a column header in excel. b) Next big idea. Each TABLE should store information about an individual type of thing and no two tables should store the same info twice. In your example, you database will probably has individual TABLES for... a) Products (FIELDS will be id, name, price, description, model number) b) Manufactures (FIELDS will be id, name, isDomestic?) c) Models (FIELDS will be id, name, manufactureId) The trick is linking them together when you QUERY for data. In this example, Honda is a row in manufacture. Accord and Civic and CRV are rows in models. Each row in the models TABLE for all the hondas would have the same manufactureId. The manufactureId in models TABLE matches the id value in Manfuactures. Stick with it, you'll get it soon ;-)

You've helped...again, Much Appreciated! I'm plowin' away at it.