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, the p.i.c. group, text em, sql price, php ajax sql, p&a group, div search, car id, auto codes, dropdown select sql car model year, form option sql result, p sql, car codes, sql java, Sql code, rice, pull-up, NISSAN, need to put a label, java sql, auto form submit, action figure, dropdown select

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 [url removed, login to view]

$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 [url removed, login to view] 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