[wizowizo]

Hi,

I have designed a simple competition which contain 3 tables, one of these tables is for the questions..
in this code I have managed to retrieve question no. 1 from the database, and I can changed it through this form and press change to send the data to the table.
Everything works fine up to now.. but I want to make it works for all the questions in my table, so I can change them all in one page.. I think there should be a way to do it by loop rather than retyping the whole code again for each question.

At the same time it would be very helpful if I can make it both for questions and answers.. in other words I can change the question and the answer and press one button to update the database table..


Any help?
PHP Code:

PHP Code:

<?php 

require ("connect.php"); 

if (isset($_POST['submit']) && isset($_POST['tochange1'])) { 

   $tochange1 = $_POST['tochange1']; 

   $changeQ1 = mysql_query("UPDATE questions SET Question='" . mysql_real_escape_string($tochange1) . "' WHERE QuestionNO = 1"); 

} 

$resultQ1 = mysql_query("SELECT question FROM questions WHERE QuestionNO=1"); 

while ($row1 = mysql_fetch_assoc($resultQ1)) { 

   echo $row1["question"]; 

} 

echo " 

<form method='POST'> 

<input type='text' name='tochange1' /> 

<input type='submit' name='submit' value='Change' /> 

</form> 

<br /> 

"; 

?>

[Jcbones]

What is the database structure for all 3 of your tables?

Using just the data from your script, it should look something like:

PHP Code:

<?php 
require ("connect.php"); 
if (isset($_POST['submit'])) { 
   foreach($_POST['change'] as $key => $value) {
        $id = (int)mysql_real_escape_string($key);
        $question = mysql_real_escape_string($value);
        $sql = "UPDATE questions SET Question = '$value' WHERE QuestionNO = $id";
        if(!mysql_query($sql)) {
            echo '<br />There was a problem with: <br />' . $sql . '<br />' . mysql_error();
        }
        else {
            echo 'All questions Updated!';
        }
    }
} 

echo "<form method='POST'> ";

$resultQ1 = mysql_query("SELECT Question, QuestionNO FROM questions"); 
while ($row1 = mysql_fetch_assoc($resultQ1)) { 
   echo '<input type="text" name="change[' . $row1['QuestionNO'] . ']" value="' . $row1['Question'] . '" />';
}

echo '<input type="submit" name="submit" value="Change" /> 
</form> 
<br />';
?>

[wizowizo]

Many thanks for your reply.. attached is the Database Diagram.

I have tried the code you modified, but I got this error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\testo.php on line 20

[Golith]

Use this acute accent ( ` ), and character which goes down from the right to the left. It's on the left hand side of my keyboard, on the left of (1 !) and above ( TAB ).

So it will be like: resultQ1 = mysql_query("SELECT Question, QuestionNO FROM `questions`");
the other reasons maybe
1.no connection present which means null (bolean) is returned
2. no rows present in db. --> can u query the db with num_rows and get the value 1 to return?

other than that i'm fresh out

[wizowizo]

Hello,

I have tried each of these options, but still got the same error..

any help?

[UnrealEd]

replace this line

PHP Code:

$resultQ1 = mysql_query("SELECT Question, QuestionNO FROM questions"); 

with this one

PHP Code:

$resultQ1 = mysql_query("SELECT Question, QuestionNO FROM questions") or die(mysql_error()); 

and tell us what you see