Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Dynamic select and input drop downs and dynamic html

Avatar of Larry Groves
Larry GrovesFlag for United States of America asked on
PHP
6 Comments1 Solution401 ViewsLast Modified:
I am pretty new to PHP but I'm getting it (if a little slowly). Anyway, I'm working on a project and I need to create a small survey. I know all about using MYSQL and APACHE with PHP but I need to use IIS6 and MS Access. Anyway, The survey is suppose to have a simple username only login for the first page. On the second page will be all of the survey questions along with their rankings. It will be something like this...
Survey 1
 Survey 1 Question 1  <SELECT DROP DOWN RANKING>
 Survey 1 Question 2  <SELECT DROP DOWN RANKING>
 Survey 1 Question 3  <SELECT DROP DOWN RANKING>

The select drop down ranking value will be 1, 2, 3 (the total amount of inputs will be based on the number of survey questions. For example, in the example above, if there were 5 survey questions then there would be 5 inputs in the select drop down. The user is suppose to select only one each. Now, there are 8 surveys and each survey has anywhere from 1 to n survey questions. I've already got the login, logout and session stuff working.I'm currently stuck on 2 things. First, I can't figure out how to get the table, tr and tds set up correctly. The way it's suppose to show up on the page is that there is suppose to be evenly devided based on the number of surveys. If there are 8 surveys there 4 surveys on the left side (first td) and 4 on the right side (second td). My second and I'm sure a more complicated problem is that I can't figure out how to populate the <select tag. Since these are all dynamic, I can't hard-code anything. Here is what I have so far:

<?php
require_once('odbc.php');
$resultcount = 0;
$query = odbc_exec($odbc, "SELECT * FROM ACTIVITY") or die (odbc_errormsg());
print "<table width='400' border='1' cellspacing='0' cellpadding='0' style='margin: 25px 0px 10px 0px;'>\n<tr>\n<td>\n\n<table>";
while($row = odbc_fetch_array($query))
{
$blah1 = $row[ACTIVITY_ID];
    print "\n<tr>\n<td><font size=+1 color=red>";
    echo $row['DESCRIPTION'];
    $active = odbc_exec($odbc, "SELECT * FROM ACTIVITY_TYPE WHERE ACTIVITY_ID = $row[ACTIVITY_ID]") or die (odbc_errormsg());
    while($actrow = odbc_fetch_array($active))
      {
    $blah2 = $actrow[ACTIVITY_ID];
            if ($blah1 = $blah2){
            print "<table>\n<tr>\n<td font size=-1 color=black>\n&nbsp;&nbsp;&nbsp;";
            echo $actrow['DESCRIPTION'];
            echo '&nbsp;&nbsp;&nbsp;<select name='.$rankrow['RANKING_ID'].'>';
                  $ranking = odbc_exec($odbc, "SELECT * FROM ACTIVITY_RANKING WHERE ACTIVITY_ID = $row[ACTIVITY_ID]") or die (odbc_errormsg());
                  while($rankrow = odbc_fetch_array($ranking))
                  {
                  echo '<option value='.$rankrow['RANKING'].'>'.$rankrow['RANKING'].'</option>';
                  }
            print "</td>\n</tr>\n</table>\n";
            }
      }
      if ($resultcount == 3) {
      print "\n</td>\n</tr></table></td>\n<td>\n<table>";
      }else{
      print "\n</td>\n</tr>";
    }
    $resultcount++;
}
print "\n</table>\n</td>\n</tr>\n</table>";
odbc_close($odbc);
?>

This actually works ok (and looks ok in IE) but as I noted above, the html isn't working and I don't know how to populate the <select name so that I can capture it once the user clicks the submit button.

I'm doing this all on my laptop so to show you an example of what I've come up with so far, I've saved the source from my browser and put it up on my friends site. The page is here - http://tests.likeanut.com/

Thanks,
biglarrrr
ASKER CERTIFIED SOLUTION
Avatar of Arrivist
Arrivist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers