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.
--- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Date: Sunday, August 29, 2004 04:35:52 AM -0700
> > Subject: [PHP-DB] 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
> > (the same people who do PHAKT). Impakt works on
> > php4 - ADODB model. Up to this point I haven't
> had to
> > understand the code all too much to make things
> > aka. inserts, deletions, updates, etc.
> > Now to why I write today.
> > I have an insert transaction form, about 10
> > 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
> > referencing StateID in the state table.
> > So far so good.
> > In my form, I want a pull down menu for the state
> > 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
> > examples I've found are exactly what I want, only
> > use preformatted values and not the database /
> > I wish to use.
> > That is pretty much my dilemma. Just not sure how
> > 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:
> ---------- End Original Message ----------
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php