Re: calling a column into a popup

yup, now i realize it is a form calling itself with a php doc. i feel like a dufus(sp?). i didn't recognize the "echo" as opposed to print so I didn't see the html coming. learning php, mysql, and database design all together. it's kinda fun, given time for a project you know. thanks to both of you. beckie > From: Steve Brett <steve.brett@e-mis.co.uk> > Date: Mon, 23 Apr 2001 16:02:02 +0100 > To: Beckie Pack <bpack@vsat.net>, php-db@lists.php.net > Subject: RE: [PHP-DB] calling a column into a popup > > becky the code below is spot on (nearly) > > stick it on a form that calls itself change the <option name= to <option > value= and when you refresh the form $company will contain the comany name. > > you can also use selected in the folowing manner > > $regs = pg_Exec($conn, "select region_id, region_name from region > where ".$depdisplay." is not null order by ".$depdisplay." "); > $numregs = pg_numrows($regs); > echo '&nbsp;Region&nbsp;&nbsp;<select name="reg" > onChange="document.thisForm.submit()">'; > echo '<option value=0>Choose a Region</option>'; > > for ($s=0; $s<$numregs; $s++) > { > $reglist = pg_fetch_array($regs,$s); > echo'<option value="'.$reglist["region_name"].'"'; > print ($region == $reglist["region_name"]) ? " SELECTED":" > "; > echo '>'.$reglist["region_name"].'</option>'; > } > > echo'</select>'; > >> -----Original Message----- >> From: Beckie Pack [mailto:bpack@vsat.net] >> Sent: 23 April 2001 15:29 >> To: php-db@lists.php.net >> Subject: Re: [PHP-DB] calling a column into a popup >> >> >> That's almost it. I want to populate the menu automatically from the >> database without having to manually modify the HTML. I >> believe the below >> will pull the data but it doesn't modify the menu in HTML. I >> tried a few >> things like using the variable name as the same as the >> co_name but the menu >> always comes up blank unless I put an option name in the >> list. it doesn't >> pass the variable for $co_name in the HTML. >> >> thanks, >> boo >> >>> From: "Johannes Janson" <johannes.janson@gmx.de> >>> Date: Sun, 22 Apr 2001 21:49:36 +0200 >>> To: php-db@lists.php.net >>> Subject: Re: [PHP-DB] calling a column into a popup >>> >>> Hi, >>> >>> let me get this right. What I understood is the following: >>> >>> 1. Your admin page where you enter the information of a company >>> 2. A Page with a drop-down list where all the company names >> are listed. >>> (These names should then be linked to an information page with more >>> info?) >>> 3. A page where new companies can be added. >>> >>> well the drop-down list you can do with a simple while and >> a select(html) >>> like >>> this: >>> $result = mysql_query("SELECT companyName FROM companyTable ORDER BY >>> companyName"); >>> echo "<select name=company>"; >>> while (list($c_name) = mysql_fetch_array($result)) { >>> echo "<option name=$c_name]>$c_name</option>"; >>> } >>> >>> If this is what you want (what I'm not sure about) I'm glad >> I understood >>> you. If not supply more detailed information. >>> >>> Cheers >>> Johannes >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >> For additional commands, e-mail: php-db-help@lists.php.net >> To contact the list administrators, e-mail: >> php-list-admin@lists.php.net >> >