I am new to Drupal and I need a bit of some guidance and perhaps a pointer to a tutorial or forum thread on what I need to know.
Firstly, I have very little experience with PHP. However, about 10 years ago, I did a lot of work with ASP and Microsoft SQL server so I do understand the basics of integrating a SQL server to a web interface. PHP seems familiar.
I did manage to get a complete Ubuntu server running mail, DNS, Apache2 and all the require PHP librarys going and have manage to develop a site with Wordpress and have got Drupal core installed on another dev site.
Admitting I was a bit confused on how Drupal all worked and had a big blank stare on my face, So I went and found a few PDFs floating around that and none of them seem to give me a good beginners steer in the right direction for what I would like to do.
What I would like to do is create a database that houses users (customers), retailers, products and perhaps other tables needed to house geo-tagging information. The products table will need to have child tables and relations so that options such as color and size can be referenced as well. Sounds like a simple deal however there is no centralized store. The products are static. Each store would need to have a geo tagged location. It would be more or less a locator service for products that are being sold. My web site would then grab the users current location and find that user the store closest to them. I would also be using that same database to interface with iOS and Android applications to query it in the same way.
Would anyone care to give me a steer in the right direction to information that would help me accomplish this creation and perhaps give me a brief explanation of how do I create a database and interface it to a Drupal front end. Obviously I should start with reading Drupal for Dummies ( ordering from amazon.com right now!) but I am eager, and I like to get on a fast track. I want to know specifically how do I create a database of my own in Drupal and query it and link tables. I would like to know how one would go about creating a web service to let iOS query the database and return the query to the app ( I just learned iOS does not have ODBC? )
I am not looking for in depth explanations here just come cliff notes and maybe some links to things i should be reading.
Oh and forgive me if this is the wrong spot for n00bs to post. Mods please shuffle me to the proper n00b question arena =)