I'm trying to make a user-searchable db. I've tried to study the database for the city/state/zipcode thing and I'm confused as hell. My server has PHP and MySQL, but I can't even fucking get Apache installed on WinXP to get PHP and MySQL installed to learn them from tutorials. Many of my ideas revolve around using MySQL. Around and around we go.
I know, I know, I'm a moron. It's fairly easy to remember code instructions, but I can't practice on my computer, and that's pretty damn useful when all of the tutorials want you have the trio installed before you start. Any help would be really helpful before I develop a concussion from banging my head against the desk.
So a visitor to my site is looking for a certain type of widget or whatever. There are several variables that s/he can include or exclude in a query, such as year of manufacture, color, features, price range, etc. When the user uses a combination of checkboxes / keywords, s/he will come up with a page listing pictures and links to descriptions of all widgets that match those parameters.
Is this even feasible in MySQL? If so, I'd really like to know how to do it. Thanks in advance.
I know, I know, I'm a moron. It's fairly easy to remember code instructions, but I can't practice on my computer, and that's pretty damn useful when all of the tutorials want you have the trio installed before you start. Any help would be really helpful before I develop a concussion from banging my head against the desk.
So a visitor to my site is looking for a certain type of widget or whatever. There are several variables that s/he can include or exclude in a query, such as year of manufacture, color, features, price range, etc. When the user uses a combination of checkboxes / keywords, s/he will come up with a page listing pictures and links to descriptions of all widgets that match those parameters.
Is this even feasible in MySQL? If so, I'd really like to know how to do it. Thanks in advance.