Re: Dropdown Building Function
| From: | Aaron Greenspan | Date: | Fri, 29 Jul 2005 22:00:06 +0000 |
| Subject: | Re: Dropdown Building Function | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-219643@lists.php.net to get a copy of this message | ||
Jay,
This is why I think frameworks are helpful Here's how I'd do it with Lampshade in one line of code with my own hypothetical field names:
dropdownBox('answerid', "SELECT answerid, CONCAT(questions.description,' - ',answers.description) AS display FROM questions LEFT JOIN answers ON questions.questionid=answers.questionid ORDER BY questions.description, answers.description", $myrow['answerid'], 'Question and Answer', 'Choose an Answer');
For more information on this function:
http://www.thinkcomputer.com/software/lampshade/documentation.html?function=dropdownBox
I'd be happy to help you get it set up if you have any questions.
Aaron
Aaron Greenspan
President & CEO
Think Computer Corporation
http://www.thinkcomputer.com