Re: [PHP] Dropdown Building Function

2005-07-30 Thread Satyam
Jack Jackson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Aaron, Thanks for showing me this it is very cool indeed. However maybe I am being dumb and obdurate but what I am really trying to do is build some of these things myself (with, thankfully, help) Perhaps this can

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Jack Jackson
Hi, can anyone even point me in a *direction*? I suppose this is the most complex thing I've ever tried to do and I have been at it for tens of hours and am still completely baffled. Jack Jackson wrote: Hi, because that last topic on multipage forms was so exciting, I decided to database

RE: [PHP] Dropdown Building Function

2005-07-29 Thread Jay Blanchard
[snip] Hi, can anyone even point me in a *direction*? I suppose this is the most complex thing I've ever tried to do and I have been at it for tens of hours and am still completely baffled. Jack Jackson wrote: Hi, because that last topic on multipage forms was so exciting, I decided to

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Kristen G. Thorson
I'm not 100% sure where you're saying you're stuck, but I think you're trying to do with one query what you will probably find is best to do with several. Hopefully the following will help some: //first get all the questions $sql = select * from questions; $result = mysql_query( $sql );

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Jack Jackson
Hi, Jay, I see perhaps I *was* thinking too complex. However this is *just* a bit off: Jay Blanchard wrote: [snip] Hi, can anyone even point me in a *direction*? I suppose this is the most complex thing I've ever tried to do and I have been at it for tens of hours and am still completely

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Jack Jackson
Kristen, Thank you so much this is precisely what I was trying to accomplish. However I was also trying to learn how to do it with those arrays you mentioned which I figure will help me emerge from total newbieness. To date, I hope the list has seen I've progressed from absolutely *no*

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Jack Jackson
And of course, I am finding that this way of yours is the easiest!! Thanks, again, Kristen JJ Kristen G. Thorson wrote: I'm not 100% sure where you're saying you're stuck, but I think you're trying to do with one query what you will probably find is best to do with several. Hopefully the

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Aaron Greenspan
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

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Jack Jackson
Aaron, Thanks for showing me this it is very cool indeed. However maybe I am being dumb and obdurate but what I am really trying to do is build some of these things myself (with, thankfully, help) so that I understand enough that when I see a great tool like yours I'll actually appreciate

Re: [PHP] Dropdown Building Function

2005-07-29 Thread David Christensen
On Fri, 2005-07-29 at 15:58 -0400, Jack Jackson wrote: Hi, can anyone even point me in a *direction*? I suppose this is the most complex thing I've ever tried to do and I have been at it for tens of hours and am still completely baffled. Jack Jackson wrote: Hi, because that last

Re: [PHP] Dropdown Building Function

2005-07-29 Thread Jack Jackson
Kristen G. Thorson wrote: I'm not 100% sure where you're saying you're stuck, but I think you're trying to do with one query what you will probably find is best to do with several. Hopefully the following will help some: //first get all the questions $sql = select * from questions;