Problem with querys or updates

IMP_TWI

For some reason it doesn't update my DB, but I know that it's correct because it worked before:

<HTML>
<link rel="stylesheet" href="quiz.css" type="text/css">
<body><center>
<P>&nbsp;</P>

<B>Admin area - edit the quiz</B>
<?php


$table = "quiz1";
$table2 = "quiz2";

/* Table fields are quiz1 - Question, QuestionID, quiz2 - Question, QuestionID, OptionID, Option, IsOptionCorrect*/


if($submit)
{
$sql = "INSERT INTO $table2 (Question, QuestionID, OptionID, Option, IsOptionCorrect) VALUES ('$Question','$QuestionID','$OptionID','$Option','$IsOptionCorrect')";
$result = mysql_query($sql);
echo "<br><br>Question added to quiz.<br><br>";


$findid = mysql_query("SELECT QuestionID FROM $table2 ORDER BY QuestionID DESC");
$myrow = mysql_fetch_array($findid);
$id = $myrow["QuestionID"];

$qsql = "UPDATE $table2 SET QuestionID='QuestionID' WHERE QuesionID=QuestionID";
$qresult = mysql_query($qsql);
}
else if($update)
{
$sql = "UPDATE $table2 SET Question='$Question',QuestionID='$QuestionID',OptionID='$OptionID',Option='$Option',IsOptionCorrect='$IsOptionCorrect'";
$result = mysql_query($sql);
echo "<br><br>The quiz has been succesfully updated.<br><br>\n";
}
else if($id)
{
$result = mysql_query("SELECT * FROM $table2 WHERE QuestionID=QuestionID",$db);
$myrow = mysql_fetch_array($result);
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type="hidden" name="QuestionID" value="<?php echo $myrow["QuestionID"]?>">
    <b>Question:</b><br>
    <input type="Text" name="Question" value="<?php echo $myrow["Question"]?>" size="50">
    <br>
    <b>QuestionID:</b><br>
    <input type="Text" name="QuestionID" value="<?php echo $myrow["QuestionID"]?>" size="30">
    <br>
    <b>OptionID :</b><br>
    <input type="Text" name="OptionID" value="<?php echo $myrow["OptionID"]?>" size="30">
    <br>
    <b>Option :</b><br>
    <input type="Text" name="Option" value="<?php echo $myrow["Option"]?>" size="30">
    <br>
    <b>IsOptionCorrect:</b><br>
    <input type="Text" name="IsOptionCorrect" value="<?php echo $myrow["IsOptionCorrect"]?>" size="30">
    <br>

<br>
<input type="Submit" name="update" value="Update information"></form>
<?

}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
    <p><br>
      <b>Question:</b><br>
      <input type="Text" name="Question" size="50">
      <br>
      <b>Question ID:</b><br>
      <input type="Text" name="QuestionID" size="30">
      <br>
      <b>Option ID:</b><br>
      <input type="Text" name="OptionID" size="30">
      <br>
      <b>Option :</b><br>
      <input type="Text" name="Option" size="30">
      <br>
      <b>Is Option Correct:</b><br>
      <input type="Text" name="OptionIsCorrect" size="30">
      <br>


  <br>
  <input type="Submit" name="submit" value="Enter information">
</p>
</form>
<?
}
?>
<a href="driver.php?x=editquizlist">Back to list of quiz questions</a>
</center>
</body>
</HTML>

YAOMK

Please update your all your query entries with the following:

mysql_query($sql) or die(mysql_error());

Then report back the error.

djjjozsi

i think one of your error is this:

UPDATE $table2 SET QuestionID='QuestionID' WHERE QuesionID=QuestionID

you forget to use the $ if you store the questionId.

what do you know about register globals? i think its you another problem.

if you send a variable with form/POST , on that page where you process them you reach with $_POST["variable_name_here"] if register_globals has set OFF ...

IMP_TWI

Parse error: syntax error, unexpected '(' in /home/tserv1l/public_html/original/files/editquiz.php on line 23

IMP_TWI

I dunno, I have the original script I was using before this that worked fine. I made a second table called 'quiz2' because I wanted to change the format and how it was being inserted. This is the normal script I used that worked fine before.

<HTML>
<link rel="stylesheet" href="quiz.css" type="text/css">
<body><center>
<P>&nbsp;</P>

<B>Admin area - edit the quiz</B>
<?php



$table = "quiz";


if($submit)
{
$sql = "INSERT INTO $table (question, opt1, opt2, opt3, answer) VALUES ('$question','$opt1','$opt2','$opt3','$answer')";
$result = mysql_query($sql);
echo "<br><br>Question added to quiz.<br><br>";
$findid = mysql_query("SELECT id FROM $table ORDER BY id DESC",$db);
$myrow = mysql_fetch_array($findid);
$id = $myrow["id"];

$qsql = "UPDATE $table SET q='q$id' WHERE id=$id";
$qresult = mysql_query($qsql);
}
else if($update)
{
$sql = "UPDATE $table SET question='$question',opt1='$opt1',opt2='$opt2',opt3='$opt3',answer='$answer' WHERE id=$id";
$result = mysql_query($sql);
echo "<br><br>The quiz has been succesfully updated.<br><br>\n";
}
else if($id)
{
$result = mysql_query("SELECT * FROM $table WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type="hidden" name="id" value="<?php echo $myrow["id"]?>">
    <b>Question:</b><br>
    <input type="Text" name="question" value="<?php echo $myrow["question"]?>" size="50">
    <br>
    <b>Option 1:</b><br>
    <input type="Text" name="opt1" value="<?php echo $myrow["opt1"]?>" size="30">
    <br>
    <b>Option 2:</b><br>
    <input type="Text" name="opt2" value="<?php echo $myrow["opt2"]?>" size="30">
    <br>
    <b>Option 3:</b><br>
    <input type="Text" name="opt3" value="<?php echo $myrow["opt3"]?>" size="30">
    <br>
    <b>Answer</b> (must be identical to correct option):<br>
    <input type="Text" name="answer" value="<?php echo $myrow["answer"]?>" size="30">
    <br>
    <br>
<input type="Submit" name="update" value="Update information"></form>
<?

}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
    <p><br>
      <b>Question:</b><br>
      <input type="Text" name="question" size="50">
      <br>
      <b>Option 1:</b><br>
      <input type="Text" name="opt1" size="30">
      <br>
      <b>Option 2:</b><br>
      <input type="Text" name="opt2" size="30">
      <br>
      <b>Option 3:</b><br>
      <input type="Text" name="opt3" size="30">
      <br>
      <b>Answer</b> (must be identical to correct option):<br>
      <input type="Text" name="answer" size="30">
      <br>
      <br>
      <input type="Submit" name="submit" value="Enter information">
    </p>
    </form>
<?
}
?>
<a href="editquizlist.php">Back to list of quiz questions</a>
</center>
</body>
</HTML>

djjjozsi

after you insert into mysql, its ID number could ask with:

$id=mysql_insert_id();

djjjozsi

do not update the table's ID if it is primary - auto increment.