Right, I realize that as mentioned in my post. I thought this would be the best place though to ask how people work around this. Thank you, Stuart --- php-list-replies@xxxxxxxxxxxxxxxxxxxxx wrote: > php is server-side. i.e., until the page is returned > to the server > the user's selections are unknown so no action can > be taken on them. > e.g., with php you can't get the selected state's > city list until the > user's request is submitted and a "new" page (with > the specific city > list) is returned to the user. > > > > ---------- Original Message ---------- > > From: Stuart Felenstein <stuart4m@xxxxxxxxx> > > To: php-db@xxxxxxxxxxxxx > > Date: Sunday, August 29, 2004 04:35:52 AM -0700 > > Subject: New to the list > > > > also new to php and databases. > > Brief background to set the stage: > > I'm attempting to build a site. I'm using > > Dreamweaver, mySQL, and a RAD product called > Impakt > > (the same people who do PHAKT). Impakt works on > the > > php4 - ADODB model. Up to this point I haven't > had to > > understand the code all too much to make things > work, > > aka. inserts, deletions, updates, etc. > > > > Now to why I write today. > > I have an insert transaction form, about 10 > fields. > > Two of those fields are for "city" and "state". I > > have two tables: > > > > State Table: | City Table: > > (innodb) | (innodb) > > StateID (Primary Key) | CityID > > State | StateID > > City > > > > The city table has a foreign key on the StateID > field > > referencing StateID in the state table. > > > > So far so good. > > > > In my form, I want a pull down menu for the state > and > > a list / menu for the City. (You can probably > > anticipate the question) When a selection is made > > from the state list I want the city menu / list to > > reflect the associated cities. > > > > Now I already know that using pure PHP I would > need to > > have the state selection set up as a post vars and > > pass it into another page. Unfortunately it can't > > work that way. > > > > So, I dug around more and see for behaviour like > this, > > typically you would need to use javascript. The > > examples I've found are exactly what I want, only > they > > use preformatted values and not the database / > tables > > I wish to use. > > > > That is pretty much my dilemma. Just not sure how > to > > go about it to make it work. > > > > Appreciate any help or suggestions! > > > > Thank you, > > Stuart > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > ---------- End Original Message ---------- > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
