Trying to create a searchable database
First of all, I will say that I'm good with HTML and a little java, but I've never really worked with PHP or MYSql. The more research I do, I'm figuring out that I need PHP and MYSql for what I want to do.
I'm trying to create a database with the following fields: state, price, item
Then I want to create a search form on my website with the following search areas:
Location (drop down box with states)
Price (drop down box with "up to $10,000", "up to $25,000", "up to $50,000", "up to $100,000", and "any price")
Item (drop down box with 7 different items)
In the database, each item will have an i.d. number. Then, when the user searches, I want a picture displayed with the price and location. The picture will be clickable to take the user to the info sheet.
Is there an easy way to do this? Thanks in advance for any input!!!