php and database

[the_vagrant]

OK it's a bit complicated. So my mate is setting up this small company for car import and he needs a website. So far so good-it's ok with me except he wants something that i can't figure out how to do. he wants to make something like an advanced search engine(make, price and year of production) which could allow his clients to find quickly what they are looking for. So here's where i'm stuck:

 

i've got my form:

 

<form id="form11" action="result.php" enctype="multipart/form-data" name="form11">
<label for="make">Select a make</label>
<select id="make" name="make">
<option value="Audi">Audi</option>
<option value="BMW">BMW</option>
</select>
<label for="price">Price range</label>
<select id="price" name="price">
<option value="1">1000-2000</option>
<option value="2">2000-4000</option>
<option value="3">4000-8000</option>
<option value="4">8000+</option>
</select>
<label for="year">Year of production</label>
<select id="year" name="year">
<option value="95">1995</option>
<option value="96">1996</option>
<option value="97">1997</option>
<option value="98">1998</option>
</select>
</form>

 

well obviously that's not the complete form but the question is-how do i set up a database and how do i make the php script that can generate the results extracted from the database. Help will be really appreciated!

 

Thanks for your attention.

[Psycho]

That question would require way too much detail to answer than would be appropriate for a forum post. There are plenty of tutorials out there on PHP and databases. I suggest you look up a couple. Before you start coding you will want to design your database.