Repeating Records Question

jrmontg

I am trying to build a survey for my site. All items are stored in a mysql database.

Here is my php code:

<?php do { ?>
                <tr>
                  <td><?php echo $row_rsQuestion['SurveyQuestion']; ?></td>
                  <td><table width="14%"  border="0">
                    <tr>
                      <td><?php echo $row_rsAnswer['SurveyAnswerKey']; ?></td>
                      <td><input <?php if (!(strcmp($row_rsAnswer['Answer'],"radiobutton"))) {echo "CHECKED";} ?> name="<?php echo $row_rsQuestion['SurveyQuestionKey']; ?>" type="radio" value="radiobutton">
                        <input name="SurveryQuestionKey" type="hidden" id="SurveryQuestionKey" value="<?php echo $row_rsQuestion['SurveyQuestionKey']; ?>"></td>
                    </tr>
                  </table>
                  </td>
                </tr>
                <?php } while ($row_rsQuestion = mysql_fetch_assoc($rsQuestion));  ?>

I can repeat the questions

I cannot repeat the Answer's

Should look like this
(the 0s are radio buttons)

Question 1 - 0 1 0 2 0 3 0 4 0 5
Question 2 - 0 1 0 2 0 3 0 4 0 5
Question 3 - 0 1 0 2 0 3 0 4 0 5
Question 4 - 0 1 0 2 0 3 0 4 0 5
Question 5 - 0 1 0 2 0 3 0 4 0 5

I am going to pass the AnswerKey and the QuestionKey to a Database table.

wilku

I don't fully understand what you're trying to do. Do you have possible answers stored in a database or is it always a number from 1 to 5?

Anyway, you should create another loop inside do-while one to show possible answers.

Another thing, that seems weird to me, is why you use do-while instead of while. The way you do it, the first run of a loop goes without $row_rsQuestion set.

jrmontg

Thanks for the reply

Honstly I don't know how I should loop it.

The Answer table looks like this

SurveyAnswerKey | Answer

1 - Very Dissatisfied
2 - Dissatisfied
3 - Neither Satisfied Or Dissatisfied
4 - Satisfied
5 - Very Satisfied

wilku

I'd write it like this (haven't checked it for errors):

<?php while ($row_rsQuestion = mysql_fetch_assoc($rsQuestion)) { ?>
                <tr>
                  <td><?php echo $row_rsQuestion['SurveyQuestion']; ?></td>
                  <td><table width="14%"  border="0">
                    <tr>
            <?php for ($i=1; $i<=5; $i++) { ?>
                      <td><?php echo $i; ?></td>
                      <td><input name="<?php echo $row_rsQuestion['SurveyQuestionKey']; ?>" type="radio" value="<?php echo $i;?> 
<?php if ($row_rsAnswer['Answer']==$i) echo "CHECKED";?>">
                        </td>
               <?php }//end of for ?>
                    </tr>
                  </table>

              </td>
            </tr>
            <?php }  ?>

Or I totally misunderstood your problem...

jrmontg

Almost there,thanks

For my test I have a total of ten records I am only displaying 9.

I added more records to find that it is removing the first record that should be displayed.

I reordered the records and confirmed that it always removes the first record.

wilku

Are you sure there is no ($row_rsQuestion = mysql_fetch_assoc($rsQuestion) earlier in the code? If so, return to do-while loop and see if it's working.

jrmontg

Yes, oh course. Thanks.

I just removed the other ($row_rsQuestion = mysql_fetch_assoc($rsQuestion) it was not needed.