Lukket

Dropdown Form from SQL results.

Hello im pretty new at this and am losing my mind. i have found and tried a lot of the "codes" etc out there with no luck.

This will be for an "auto/car search" All the makes/models/prices etc loaded into this form along with zipcodes. Here is the form

<form id="SearchForm3" action="">

<div>

<label><strong>Make</strong><br />

<select name="makers">

<option>All Makers</option>

<option>nissan</option>

</select>

</label>

<label><strong>Model</strong><br />

</label>

<label><strong>Maximum P

<select name="model">

<option>All Models</option>

<option>750</option>

</select>

rice</strong><br />

<select name="price">

<option>Any</option>

<option>20000</option>

</select>

</label>

<div class="container">

<label class="left"><strong>Search Within</strong><br />

<select name="search" class="miles">

<option>50 miles</option>

<option>10 miles</option>

</select><em>of</em>

</label>

<label class="zip"><strong>ZIP</strong><br /><input type="text" value="" class="input" /></label>

</div>

</div>

<div class="alignright">

<a href="#" class="link" onclick="[url removed, login to view]('SearchForm').submit()"><strong><strong>search&nbsp;new</strong></strong></a>

</div>

</form>

So i need to put these query results in

<?php

include ("inc/[url removed, login to view]") ;

$sql=" SELECT DISTINCT modelYear, divID, divName, modelName, modelDivID

FROM chrome_divisions, chrome_models

WHERE modelDivID = divID

AND modelYear = 2011

AND divID = '$Make'

AND modelName = '$Model'

GROUP BY modelYear, divName, modelName;

";

$sql="SELECT LogMonth, LogYear FROM Student_MLog WHERE Student_ID='$username'";

$result=mysql_query($sql);

while ($row=mysql_fetch_array($result)) {

$modelYear=$row["Year"];

$divName=$row["Make"];

$modelName=$row["Model"];

echo "<option>$divName<option/>";

}

echo "<select/>";

?>

So once someone clicks "Nissan" Then only nissan models will pull up. Or Chevrolet and only chevy results pull up. From what i understand is that i might need to use AJAX or Java which i cant figure out yet. Anyhelp please!!!!!!!!!

Also,

I need something that will have locations as well. I need something so taht as soon as they come to my site i can grab there zip code or in the form on listed above the zipcode has to be mandantory.

Færdigheder: AJAX, Javascript, MySQL, PHP, Web Design

Se mere: form dropdown, dropdown form sql, zip car, text em, sql price, php ajax sql, div search, car id, auto codes, form option sql result, p sql, car codes, sql java, sql code, rice, nissan, need put label, java sql, auto form submit, action figure, dropdown select, input dropdown php, sql javascript, php sql code, dropdown search form

Om arbejdsgiveren:
( 1 bedømmelse ) royal oak, United States

Projekt-ID: #930429

42 freelancere byder i gennemsnit $252 for dette job

zeee

Hi, please see PMB.

$250 USD på 1 dag
(230 bedømmelser)
8.1
agilesols

please check your inbox.thanks

$250 USD in 0 dage
(219 bedømmelser)
7.5
gafprogrammer

Can do it right away. Assure 100% satisfaction.

$250 USD på 1 dag
(311 bedømmelser)
7.4
jqMike

Can do it to match your exact requirements. Please contact asap to discuss details.

$250 USD på 1 dag
(81 bedømmelser)
7.1
phpgenin

hy. i can do the script for you. done something similar before so not a problem doing it again. see reviews for references to my previous projects. thank you, alex

$250 USD in 2 dage
(79 bedømmelser)
7.1
determined

Professional php, ajax and sql developer here. Please check your inbox. Thanks

$250 USD på 1 dag
(52 bedømmelser)
7.1
shmai

Ready to start Right way!!!

$250 USD på 1 dag
(93 bedømmelser)
6.7
asarfraz

Please check PM

$250 USD på 1 dag
(85 bedømmelser)
6.5
shuiwatermizu

please see pm

$260 USD in 2 dage
(97 bedømmelser)
6.4
GFsoul

plz view my message i can do your project very fast.

$250 USD på 1 dag
(118 bedømmelser)
6.3
webmagics

Hello, We can do it.Please see PMB for details. Thanks

$300 USD in 3 dage
(45 bedømmelser)
6.2
RedhopIT

Hi.i've done exactly the same thing before , please check PM for details.

$250 USD in 0 dage
(76 bedømmelser)
6.2
utpal4job

Hello, I am interested to do this project. Please refer INBOX. Thanks.

$250 USD på 1 dag
(65 bedømmelser)
5.9
allhen

REady to help you !!

$250 USD in 3 dage
(64 bedømmelser)
5.8
smartgest

I have experience on this.

$250 USD in 0 dage
(31 bedømmelser)
5.6
gutibs

Please check PMB for details. Thanks !!!!!

$250 USD in 0 dage
(44 bedømmelser)
5.1
cuzinet

see pm please

$250 USD på 1 dag
(14 bedømmelser)
4.9
ciachn

Hi, check PMB.

$250 USD in 3 dage
(8 bedømmelser)
4.8
infowayphoenix

hi, Please check PMB..

$250 USD på 1 dag
(13 bedømmelser)
4.8
peteruk

I will drop you a Private Message.

$250 USD på 1 dag
(14 bedømmelser)
4.7