Best language for search options and can MS Access be used as a search database

[matt_b_19]

I’m trying to build my first real website so unfortunately I don’t have any great knowledge of the subject. I can do basic HTML and at one point I could program in Turing but I’m pretty sure that’s worthless. Anyway, I’m trying to build a website that is primarily a search function. It would have a variety of search options (for example, “Price,” “colour,” and other functions). These would then return results that would match all the selected relevant queries. I’m also interested in making the search bars have options (such as for “Price” have a “between” option (eg. Between $10 and $20)). While I have found how to make a search bar in HTML, to my understanding I can’t make a search option this specific in it. So which programming language would you guys recommend for me to approach this in? I’ve heard that PHP is the best for this especially with my very limited skill.

Another big question is would there be a way for me to link the search options to an MS Access database (or MS Excel, but I would imagine Access would be more likely to work). So basically I’d have a database with each row being a product and along it would be all the information for the search (price, colour…etc) and whenever you’d use the search, it would rely off this database.

Sorry this is so much to ask, I’m just more at a loss of where to start (other than get educated which goes back to which language I should use :P). Any help is greatly appreciated. Thank you ahead of time

[jerry62704]

Your database would have to be on the server, unless your home machine is also a 24/7 server. Most ISPs have mysql on them that you can use.

PHP will connect the queries you build on your web page with the database. Most ISPs have this as well.

Depending on the time frame, you can do all this. We all started from nowhere to begin with. If it is time sensitive, you may have to pay someone. There is a place on this forum where you can get prices and such.

If you have the time, try starting at w3schools.com and take the tutorial on HTML and SQL to start.

The data entry part (the form on your page) might benefit from javascript to validate the data before you make a server request. They have a tutorial for that too.

[matt_b_19]

Oh this is the information that I'm looking for. Thank you very kindly. After looking into your suggestions more, SQL should work perfectly and I looking into this w3school.com and the tutorials seem great. Time isn't a factor for me, it's really just a side thing that I'm doing while I'm bored at work or home, like a hobby I guess.

Thanks a lot for all your help, you answered my question perfectly