Re: [PHP-DB] Multiple select box using mysql

2003-02-26 Thread Jason End
Yeah, I think I am going to reconsider the software box. The idea I have now is to have an Add Expert link attached to each software entry, which will then load a page to add experts to that piece of software. The page could contain two select boxes, one with a list of all experts, and one with a

Re: [PHP-DB] Multiple select box using mysql

2003-02-24 Thread Jason End
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 [EMAIL PROTECTED] wrote: You have to give the

Re: [PHP-DB] Multiple select box using mysql

2003-02-24 Thread Mark
I'm not sure if anyone answered this for you, and perhaps I'm missing something. Are you simply trying to populate a multi-select box with MySQL data? If so, try this: echo form tag here... echo SELECT NAME=\software[]\ MULTIPLE SIZE=5; $query=select ID, Name, Version from software;

[PHP-DB] Multiple select box using mysql

2003-02-18 Thread Jason End
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

Re: [PHP-DB] Multiple select box using mysql

2003-02-18 Thread Corne' Cornelius
You have to give the Mutli select box a name as an array. eg: SELECT NAME=experts[] MULTIPLE SIZE=5 OPTION VALUE=key1val1/OPTION /SELECT then in PHP, you can access $experts as an array. while (list ($key, $val) = each($experts)) { print $key = $valBR\n; } Jason End wrote: I writing a