I am game for anything that works and works fast and easy. I am just wondering if I am opening up a whole new can of worms? Cheers! Brad -----Original Message----- From: George Pitcher [mailto:george.pitcher@xxxxxxxxxxx] Sent: Tuesday, June 12, 2007 6:06 AM To: BSumrall Subject: RE: Looking for help with forms/variables and an array! Hi, I use Javascript. I also use Firefox. I use Apache as my server on WinNT, but Ajax also works on Linux servers (mainly because its a client-side application). Let me know if you need help setting up Ajax and/or testing. Cheers George > -----Original Message----- > From: BSumrall [mailto:Brads@xxxxxxxxx] > Sent: 12 June 2007 10: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
