Update problem

[Tezread]

This is properly doing my head in and I would really appreciate anyones guidance.
I have a form with a listbox that looks up a coursename:

echo "<option value='".$row['coursecode']."'>".$row['coursename']."</option>\n";

then you can fill in the rest of the details in the form click submit and a file called updatecourseformhandler.php does the update of the db. Im having trouble passing the chosen coursename variable from my form to the form handler page so the details of the chosen coursename are not updated Here is my code in the form handler.

<?php
$user = "root";
$host = "localhost";
$password = "";
$connection = @mysql_connect($host, $root, $password)
or die ("Couldn't connect to server.");
$database = "courses";
$db = @mysql_select_db($database, $connection)
or die ("Couldn't select database.");

if (isset($_POST['Submit'])) {
//insert the values entered into the courseentry form into the database

$coursename = $POST['coursename'];
$accreditingbody = $POST['accreditingbody'];
$briefdesc = $POST['briefdesc'];
$aimedat = $POST['aimedat'];
$level1 = $POST['level1'];
$level2 = $POST['level2'];
$level3 = $POST['level3'];
$elearning = $POST['elearning'];
$facetoface = $POST['facetoface'];
$blended = $POST['blended'];
$elearningtime = $POST['elearningtime'];
$facetofacetime = $POST['facetofacetime'];
$blendedtime = $_POST['blendedtime'];

$sql = "UPDATE trainingtopics SET coursename = '$coursename',accreditingbody ='$accreditingbody', briefdesc = '$briefdesc',aimedat = '$aimedat',level1 = '$level1',level2 = '$level2',level3 = '$level3',elearning = '$elearning',facetoface = '$facetoface',blendedlearning = '$blended',elearntime = '$elearningtime',facetime = '$facetofacetime',blendedtime = '$blendedtime'"
where coursename = $coursename
or die (mysql_error().'<hr /><pre>'.$sql.'</pre>');
//execute query and store the result
$res = mysql_query($sql,$connection);

//check to make sure the query actually ran

if(!$res) {
echo mysql_error("Update successful").":".mysql_error()."";
return 0;

//$result = $db->query($sql);
echo $sql;
}
}

?>

[vaaaska]

Your listbox does have a name right?

name='coursename'

And you do have form tags right?

Without more info...and/or seriously inspecing your query code, I don't see any problems. Oh wait...except this isn't right (I'm updating it here):

$sql = "UPDATE trainingtopics SET 
coursename = '$coursename',
accreditingbody ='$accreditingbody', 
briefdesc = '$briefdesc',
aimedat = '$aimedat',
level1 = '$level1',
level2 = '$level2',
level3 = '$level3',
elearning = '$elearning',
facetoface = '$facetoface',
blendedlearning = '$blended',
elearntime = '$elearningtime',
facetime = '$facetofacetime',
blendedtime = '$blendedtime' 
WHERE coursename = '$coursename'"; // compare to the original and you'll see the changes

Be sure you validate your data too...

[Tezread]

The record is still not updating. Here is my form (updatecourseentry.php)

<?php
$user = "root";
$host = "localhost";
$password = "";
$connection = mysql_connect($host, $root, $password) or die ("Couldn't connect to server.");
$database = "courses";
$db = mysql_select_db($database) or die ("Couldn't select database.");

$sql = "SELECT coursename FROM trainingtopics";

$result = mysql_query($sql) or die(mysql_error());
echo $result."=result<br>";

while($row=mysql_fetch_array($result))
{
echo "<option value='".$row['coursecode']."'>".$row['coursename']."</option>\n";
}
?>
</select>

><br>
  <br>
  <input type='text' name='accreditingbody' value='accreditingbody'>
  <br>
  <br>
  <textarea name="briefdesc" cols="75" id="briefdesc"></textarea>
  <br>
  <br>
  <textarea name="aimedat" cols="75" id="aimedat"></textarea>
  <br>
  <br>
  <select name="level1" size="1" id="level1">
    <option>Yes</option>
    <option>No</option>
    <option>Not selected</option>
  </select>
  <br>
  <br>
  <select name="level2" size="1" id="level2">
    <option>Yes</option>
    <option>No</option>
    <option>Not selected</option>
  </select>
  <br>
  <br>
  <select name="level3" size="1" id="select2">
    <option>Yes</option>
    <option>No</option>
    <option>Not selected</option>
  </select>
  <br>
  <br>
  <select name="elearning" size="1" id="select3">
    <option>Yes</option>
    <option>No</option>
    <option>Not selected</option>
  </select>
  <br>
  <br>
  <select name="facetoface" size="1" id="select4">
    <option>Yes</option>
    <option>No</option>
    <option>Not selected</option>
  </select>
  <br>
  <br>
  <select name="blended" size="1" id="select5">
    <option>Yes</option>
    <option>No</option>
    <option>Not selected</option>
  </select>
  <br>
  <br>
  <input name="elearningtime" type="text" id="elearningtime" value="" size="50">
  <br>
  <br>
  <input name="facetofacetime" type="text" id="facetofacetime" value="" size="50">
  <br>
  <br>
  <input name="blendedtime" type="text" id="elearningtime" value="" size="50">
  <br>
  <br>
  <input type="submit" name="Submit" value="Update">      
<input type="reset" name="reset" value="Reset">

</form>
<br>
<br>
<br>
<br>
<br>
</div>
</form>

and here is the formhandler that is supposed to take the selected coursename from the dropdown box in updatecourseentry.php as well as anything inputted into the form and update the record:
<?php
$user = "root";
$host = "localhost";
$password = "";
$connection = @mysql_connect($host, $root, $password)
or die ("Couldn't connect to server.");
$database = "courses";
$db = @mysql_select_db($database, $connection)
or die ("Couldn't select database.");

if (isset($_POST['Submit'])) {
//insert the values entered into the courseentry form into the database

$coursename = $POST['coursename'];
$accreditingbody = $POST['accreditingbody'];
$briefdesc = $POST['briefdesc'];
$aimedat = $POST['aimedat'];
$level1 = $POST['level1'];
$level2 = $POST['level2'];
$level3 = $POST['level3'];
$elearning = $POST['elearning'];
$facetoface = $POST['facetoface'];
$blended = $POST['blended'];
$elearningtime = $POST['elearningtime'];
$facetofacetime = $POST['facetofacetime'];
$blendedtime = $_POST['blendedtime'];

$sql = "UPDATE trainingtopics SET

coursename = '$coursename',
accreditingbody ='$accreditingbody',
briefdesc = '$briefdesc',
aimedat = '$aimedat',
level1 = '$level1',
level2 = '$level2',
level3 = '$level3',
elearning = '$elearning',
facetoface = '$facetoface',
blendedlearning = '$blended',
elearntime = '$elearningtime',
facetime = '$facetofacetime',
blendedtime = '$blendedtime'
WHERE coursename = '$coursename'";
or die (mysql_error().'<hr /><pre>'.$sql.'</pre>');
//execute query and store the result
$res = mysql_query($sql,$connection);

//check to make sure the query actually ran

if(!$res) {
echo mysql_error("Update successful").":".mysql_error()."";
return 0;

//$result = $db->query($sql);
echo $sql;
}
}

?>

[vaaaska]

So, according to your code your <select> has no starting tag or name...is that right?

[Tezread]

the code I posted is what im using at the moment. What do I need to do?

[vaaaska]

Go back to some old thread you created from a few days ago...because I saw somebody point this out then...

[Tezread]

Hello- sorry for being a thickie - ibe had a look at my old threads and still can't see where im going wrong. Can anyone help our on this?

[LoganK]

echo "<select name='coursename'>"

before your while() statement.

And of course, after it, echo "</select>"