Updating data from MYSQL

[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
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 />
";
?>

[NogDog]

Welcome to the forums, "wizo". Note that I edited your post to add this forum's [noparse]

 ... 

[/noparse] bbCode tags around your code snippet in order to make it easier to read. (While I was in there, I added a bit of indenting, too. 🙂 )

[Emma]

This is the sort of thing I would do, it's not got all the code for a whole page but you get the general sense of how to use the loop.

require ("connect.php");
if (isset($_POST['submit']) && $_POST['submit'] == "UPDATE") {
	foreach($_POST as $key => $value){
		# Check if current $_POST is a question
		$currentKey = strpos($key,"question");
		if($currentTextKey !== FALSE){
			# Get the question ID
			$keyid = str_replace("question","",$key);
   		$question = mysql_query("UPDATE questions SET Question='" . mysql_real_escape_string($value) . "' WHERE QuestionNO = ".$keyid);
		}
	}
}
# Name the input boxes to match the question/answer IDs.
# Ideally do this programmatically
echo "
<form method='POST'>
	<input type='text' name='question1' />
	<input type='text' name='answer1' />
	<input type='text' name='question2' />
	<input type='text' name='answer2' />
	<input type='submit' name='submit' value='UPDATE' />
</form>
<br />
";