Re: Multiple select box using mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



But how do I populate the array with (for e.g.) 2
fields from a mysql table. Each line of the select box
needs to hold the Name and Version of the piece of
software, the results from a:
select Name, Version from software

-s-

--- Corne' Cornelius <cornec@reach.co.za> wrote:
> You have to give the Mutli select box a name as an
> array. eg:
> 
> <SELECT NAME="experts[]" MULTIPLE SIZE=5>
> <OPTION VALUE="key1">val1</OPTION>
> </SELECT>
> 
> then in PHP, you can access $experts as an array.
> 
> while (list ($key, $val) = each($experts))  {
>    print "$key = $val<BR>\n";
> }
> 
> 
> Jason End wrote:
> 
> >I writing a software catalog that features
> "experts",
> >who a people especially skilled in a piece of
> >software. My db, has a "software" table and an
> >"experts" table. 
> >I need to have a page that generates 2 multiple
> select
> >boxes, each on with the data from each table. 
> >>From there one will be able to choose the software
> >program and the experts, which will then record the
> >software-expert relationship in the DB. 
> >
> >The problem is that I don't really understand how
> to
> >populate multi select boxes with db data, and then
> >have the selections passed back as inserts. 
> >
> >Can someone clue me in?
> >
> >thanks, 
> >
> >Jay
> >
> >__________________________________________________
> >Do you Yahoo!?
> >Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> >http://mailplus.yahoo.com
> >
> >  
> >
> 
> 
> 
> 
> =============Disclaimer and
> Confidentiality===================
> This message contains information intended for the
> perusal, and/or use (if so stated), by the stated
> addressee(s) only. The information is confidential
> and privileged. If you are not an intended
> recipient, do not peruse, use, disseminate,
> distribute, copy or in any manner rely upon  he
> information contained in this message (directly or
> indirectly). The sender and/or the entity
> represented by the sender shall not be held
> accountable in the event that this prohibition is
> disregarded. If you receive this message in error,
> notify the sender immediately by e-mail, fax or
> telephone representations contained in this message,
> whether express or implied, are those of the sender
> only, unless that sender expressly states them to be
> the views or representations of an entity or person,
> who shall be named by the sender and who the sender
> shall state to represent. No liability shall
> otherwise attach to any other entity or person.
>
======================================================
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux