Re: calling a column into a popup
| From: | Johannes Janson | Date: | Sun, 22 Apr 2001 19:49:36 +0000 |
| Subject: | Re: calling a column into a popup | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8794@lists.php.net to get a copy of this message | ||
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
"Beckie Pack" <bpack@vsat.net> schrieb im Newsbeitrag
news:B7061660.2ABF%bpack@vsat.net...
> I'm creating a database where I'd like to relate a company name field to
all
> the field in the database (mysql). what i'm trying to do is have a field
> pop up with all the current company names in a pop up list on a browser.
so,
> for example, using a form i can enter all the data for a company including
> name, address, etc. what i'm trying to do is have a popup for the company
so
> if the information is already entered it is there for selection or the
> person can enter a new company if it's not there.
>
> any ideas?
>
> thanks,
> beckie
>
>
> --
> 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
>