-----Original Message----- From: BSumrall [mailto:Brads@xxxxxxxxx] Sent: Tuesday, June 12, 2007 5:54 AM To: 'George Pitcher' Subject: RE: Looking for help with forms/variables and an array! Interesting suggestion. I though ajax was mainly gear towards microsoft and javascripting applications? -----Original Message----- From: George Pitcher [mailto:george.pitcher@xxxxxxxxxxx] Sent: Tuesday, June 12, 2007 5:42 AM To: BSumrall Subject: RE: Looking for help with forms/variables and an array! Hi, Have you looked at Ajax? This will do just what you have described. When the user makes their first choice, Ajax queries the database to return the options for the secont drop-down box. George > -----Original Message----- > From: BSumrall [mailto:Brads@xxxxxxxxx] > Sent: 12 June 2007 9:34 am > To: php-general@xxxxxxxxxxxxx > Subject: RE: Looking for help with forms/variables and an array! > > > I got a little bit further, but still feel like the "monkey with a > light-bulb"! > > <OPTION value="1">Over $2 million</OPTION> > > > > -----Original Message----- > From: BSumrall [mailto:Brads@xxxxxxxxx] > Sent: Tuesday, June 12, 2007 4:21 AM > To: php-general@xxxxxxxxxxxxx > Subject: Looking for help with forms/variables and an array! > > > Dreamweaver help me with a good part of this, but now I am in the nitty > gritty code and trying to figure out. > > General concept: > > A selection box has 4 options, php queries the Mysql database for matching > options. > > Then a second options box with another 4 options filters the query even > more. > > Aspects I am a little stuck on. > > 1 associating options (in drop down box) with a variable > 2 carrying the result set over two the second drop down box > > Producing my final result set. > > Here are some snippets of where I am at. > > First selection box: > > <form id="form1" name="form1" method="post" action=""> > <label>market > <select name="select"> > <OPTION>option1</OPTION> > <OPTION>option2</OPTION> > <OPTION>option3</OPTION> > <OPTION>option4</OPTION> > </select> > > > > Second selection box: > > <form id="form2" name="form2" method="post" action=""> > <label>market > <select name="select"> > <OPTION>option1</OPTION> > <OPTION>option2</OPTION> > <OPTION>option3</OPTION> > <OPTION>option4</OPTION> > </select> > > > $query_Recordset1 = "SELECT * FROM lstng_tbl WHERE range = '1'"; > > The number one is what the first set of just above is what form one is > supposed to change. > > After that, how is the world am I going to do it twice for the second part > of the query? > > Some good literature on how to do it TWICE would really help understand > this. > > I find tons of stuff on doing it once! > > Thank you kindly for any guidance you can provide. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
