Posted by Aaron Greenspan on 07/30/05 01:00

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

• Next in forum: Re: [PHP] Dropdown Building Function
• Prev in forum: Re: [PHP] Dropdown Building Function
• Thread view: Re: [PHP] Dropdown Building Function

[Reply to this message]