CODEWITHSUNDEEP
mysqldatabase
reba elliott
reba elliott

Reputation: 79

mySQL query returns only one result

I am trying to get each row in a table to appear as part of a survey. The following code is returning only the first row in the table (so users can see only one question). I've been over and over this and can't see what I'm doing wrong. Would much appreciate any input.

Thank you!

function getQuestions ($dbc) <!--$dbc=database connection-->  {
$query = "SELECT * FROM survey_questions" <!--survey_questions=table-->  ;
$result = @mysqli_query ($dbc, $query);

while ($row = mysqli_fetch_array ($result, MYSQLI_ASSOC) )  {
    $body = $row ['question_body'] <!--question_body=row in table-->  ;

        echo '
            <div class="entry">  <!--user entry form-->
            <h3 class="qTitle">'.$body.'</h3>
                <form action="index.php" method="post">
                    <input type="text" name="answer" size="85" />
                    <input type="submit" value="Submit" name="submit" />
                    <input type="hidden" name="questionid" value="questionid" />
                    <input type="hidden" name="submitted" value="1" />
                </form>
            </div> 
        ';

}

}

Upvotes: 1

Views: 189

Answers (2)

reba elliott
reba elliott

Reputation: 79

The results are now two entry forms (an improvement) but still not displaying the text of the two rows from the database. Instead of the row text, I get the > character where the text should be. Here is the updated code, adapting the suggestion of @Mr. Alien:

function getQuestions($dbc) {

$result = mysqli_query($dbc, "SELECT * FROM survey_questions");

 while ($row = mysqli_fetch_array ($result) )  {
         echo ' 
              <div class="entry">  
              <h3 class="qTitle">'. $row['survey_questions'].'></h3>
                   <form action="index.php" method="post">
                        <input type="text" name="answer" size="85" >
                        <input type="submit" value="Submit" name="submit" >
                        <input type="hidden" name="questionid" value="questionid" >
                        <input type="hidden" name="submitted" value="1" >
                  </form>
             </div> 
        ';
    }
}

Upvotes: 0

Mr. Alien
Mr. Alien

Reputation: 157284

First of all you don't need to echo so much using php...

You have to use // or /* */ to comment in PHP and not <!----> cuz that's for HTML

Secondly coming to your code..

Why you are using?

function getQuestions($dbc) //I dont know what this is doing here, why you are wrapping your code in a function???

you can simply write like this (use echo to print out your question):

<?php
$result = mysqli_query($dbc, "SELECT * FROM survey_questions");

while ($row = mysqli_fetch_array ($result) )  {
        ?>
   <div class="entry">  <!--user entry form-->
      <h3 class="qTitle"><?php echo $row['whatever']; ?></h3>
          <form action="index.php" method="post">
             <input type="text" name="answer" size="85" />
             <input type="submit" value="Submit" name="submit" />
             <input type="hidden" name="questionid" value="questionid" />
             <input type="hidden" name="submitted" value="1" />
          </form>
   </div> 
<?php
     }
?>

Upvotes: 1

Related Questions