|
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
Navigation:
[Reply to this message]
|