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 <[EMAIL PROTECTED]>
> Date: Mon, 23 Apr 2001 16:02:02 +0100
> To: Beckie Pack <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> 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 ' Region <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:[EMAIL PROTECTED]]
>> Sent: 23 April 2001 15:29
>> To: [EMAIL PROTECTED]
>> 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" <[EMAIL PROTECTED]>
>>> Date: Sun, 22 Apr 2001 21:49:36 +0200
>>> To: [EMAIL PROTECTED]
>>> 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: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail:
>> [EMAIL PROTECTED]
>>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]