[PHP-DB] Trouble with Joins
I have a survey I created that when the formis being filled out it will select values from list. The list values are other tables in the same DB. When I go to get the info again I am trying to do a left join of the two table to get the description instead of the id's associated in the table. Since I used one table several time for the values how do I, can I, join that tabel multiple times on the SELECT statement so I can get each instance of the description. Ex. In the survey I reference the usercomm table 5 times to answer different questions. Since the answer for each instance could be different how do I join the usercomm table back to the replies table several times. Thanks for any help Roland Perez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Help for list selection
I am very new to PHP. I have a survey to do and I would like to have most of the questions selected from drop down lists. I have got the part of creating a list made from a table in MySQL. Currently I open the connection and get the table for the question for every question in the survey. This seems awful cumbersome. I was wondering is there an easier way?Would it be better to open the connection once and get all tables? Thanks for any help in advance Roland Perez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Code for drop down lists
I am a novice to PHP and am trying toget a survey with drop down lists. I am stuck as to if I should connect to the DB (MySQL DB) to get the values from a table or do I imbed them in the php file? Thanks for any help in advance. Roland Perez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php