Re: [PHP-DB] Stuck on basic concept, how to .. here's how

2004-03-20 Thread dogu
John, Thanks, you just saved me a whole bunch of time! That's too bad. I'm guessing that the process of re-establishing a resource isn't too intensive so it's not a choke point for any application. It's interesting to see how different languages attack similar problems Have a great weekend.

Re: [PHP-DB] Stuck on basic concept, how to .. here's how

2004-03-19 Thread dogu
John, Your remark got me pointed in the right direction - I wasn't thinking about a second form. Figuring out the syntax took a while, but it's working. I need to do some clean up to make it a bit more elegant, but the bones are there. Todo: Disconnect the MySQL session. Figure out a way to

Re: [PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread dogu
bits together. Thanks again for the responses. Doug John W. Holmes wrote: From: "dogu" <[EMAIL PROTECTED]> I'm still not quite there, I can see the misty shape of a solution but the details are still a bit hazy. The code I posted it the whole shebang. I've made some

[PHP-DB] Re: How to use value from a pick list?

2004-03-19 Thread dogu
Sorry for the dup - I had trouble posting to the list and managed to double post. Doug Dogu wrote: I'd like to have a form that does the following: User picks a site from a dropdown list from a MySQL db (that works - code below, thanks to all those on the web who posted code for this).

Re: [PHP-DB] Stuck on basic concept, how to use a list selection?

2004-03-19 Thread dogu
John, I'm still not quite there, I can see the misty shape of a solution but the details are still a bit hazy. The code I posted it the whole shebang. I've made some attempts to 'form enable' it, but can't figure out where to put the , and submit stuff so the entire thing renders as a form an

[PHP-DB] How to use value from a pick list?

2004-03-19 Thread dogu
I'd like to have a form that does the following: User picks a site from a dropdown list from a MySQL db (that works - code below, thanks to all those on the web who posted code for this). Once the value is selected, a second query is run using the site as the 'where' clause and the results are di