PHP Insert script

david4u

Can anyone help with is code. I cannot insert values into Questionnaire....

I have tried using different methods but it is not working. Is there any error that I have made?

This is the main problem:

$query = "INSERT INTO Questionnaire VALUES (' ', '$unit_id', '$quest_id')";
$result = mysql_query($query);

.........................................................................................................

Part of the code start here

[ php ] $qtype_id = $POST['qtype_id'];
//$unit_id = $POST['unit_id'];

$query = "INSERT INTO Questions VALUES ( ' ', '$q', '$qtype_id')";
$result = mysql_query($query);
$quest_id = mysql_insert_id();

$query2 = "SELECT unit_id FROM Units WHERE unit_name='B302'";
//$result = mysql_query ($query);
$result = mysql_query ("SELECT unit_id FROM Units") or die ("Invalid query");
$unit_id = mysql_insert_id();

$query = "INSERT INTO Questionnaire VALUES (' ', '$unit_id', '$quest_id')";
$result = mysql_query($query); 

if ($result) { // if it ran ok

echo '<p>Question is registered in database.</p>';
exit(); //Quit script.
} else { // Something is not right.
   $message = '<p>Please go back and refill form.</p><p> ' . mysql_error() . '</p>';
  }
  mysql_close(); // Close database connection
 } else { // Display the form.

 }

 // Print the error message if there is one
 if(isset($message)) {
  echo '<font color="red">', $message, '</font>'; [ /php]

bo0

What error message do you get, if any?

bo0

$query=("INSERT INTO Questionnaire (column, column, column) VALUES ('','$unit_id','$quest_id');

Blulagoon

In addition to what bo0 suggests, you could also try:

$query = "INSERT INTO Questionnaire VALUES (' ','".$unit_id."','".$quest_id."')";

also its always a good idea when an sql query doesn't work to add the line
echo $query;
and see if it is what you would expect it to be. As bo0 recommends, naming the columns after the table name, even if there are only 3 so technically no need, is good practice.

Edit: Column one wouldn't happen to be an auto-increment column would it ?

Edit2: You don't want the space between [ and PHP when you want your code to appear in colour, I only put them in as it wouldn't display in a message if I didn't.

HTH - Blu