Totally lost

[Tezread]

Im at a loss for how long ive been stuck on this problem. It has been 3 days now and im still struggling.

I have a form which looks up the value of a coursename in a database and the user then fills in the rest of the form.

Then when submit is pressed the formhandler is supposed to update the coursename chosen: Here is a snippet of my form which is the drop down box listing the coursenames.

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

and here is my update code in the formhandler

<?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 = "INSERT INTO trainingtopics (coursename, accreditingbody, briefdesc, aimedat, level1, level2, level3, elearning, facetoface, blendedlearning, elearntime, facetime, blendedtime)

VALUES ('$coursename'
,'$accredtingbody'
,'$briefdesc'
,'$aimedat'
,'$level1'
,'$level2'
,'$level3'
,'$elearning'
,'$facetoface'
,'$blended'
,'$elearningtime'
,'$facetofacetime'
,'$blendedtime'
)"
or die (mysql_error());

//execute query and store the result
$res = mysql_query($sql,$connection);

//check to make sure the query actually ran

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

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

?>

I get no error messages nor does the db get updated. Please someone spare me this misery. :-)

[Tezread]

This is my update code whoops!!

<?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 'coursecode' = '$coursecode'"
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;
}
}

?>

[lmayer4]

Hi there. First thing get rid of the "@" that's why your not getting any error messages. Take those out an then tell us if you get any errors

Laura

[vaaaska]

???

$connection = @mysql_connect($host, $user, $password) // not $root

[Tezread]

done that- still no error messages

[Tezread]

hi vaaaska :-)

[BuzzLY]

A couple of points, Tez...

First, put

 and [ /php] tags around your code, so that it's a little easier for us to read.

Also, you can edit your posts if you make a mistake, instead of posting two messages in a row.

Cheers!

[Tezread]

can anyone help me on this. Ive got a project deadline for Friday and im getting desperate im sad to say

[vaaaska]

I'm coming out of retirement to tell you to read up on debugging. Your problem is common and just sitting it around and begging us to solve it is not the purpose to this place.

Do a search on this entire forum on Debugging 101. Break things down and then build it back up...you will find the solution yourself.

[Kriil]

Did you notice Vaaaska's post?

$connection = @mysql_connect($host, $root, $password)

There is no such variable as $root in your code...I think you meant to use $user here instead and of course lose the @

also instead of

//execute query and store the result
$res = mysql_query($sql,$connection);

//check to make sure the query actually ran

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

You can use

$res = mysql_query($sql,$connection) or die("Query failed : " . mysql_error());

Of course that doesn't matter, I just like to be consistent in my code

Ok, since it appears you are testing this on your local machine you need to check your php.ini file and set display_errors = Off to display_errors = On

Now you can see your error messages.

Besides the connection string, I don't see any other problems in your code...the first thing i would do is echo a _POST variable to the screen to make sure your form from the previous page is sending the POST data.

Post again, after you try all this

Kriil

[Tezread]

Vaaska there is no need to be patronising and I am not begging. When you are under pressure to get jobs done and you don't what you are doing im sure you are like a robot that has no emotions what so ever and get things done in life with no ones help.
How are people supposed to learn things without asking for examples and how are they supposed to search like you say when they do not know what to look for.

[Tezread]

Also I may add you are rude and retiring may be a good idea so people don't have to put up with such rudeness

[Tezread]

Thankyou Krill for the pointers- I will try these

[BuzzLY]

Tez... please stop multiposting... If you are the last person to post and you want to add a comment, simply edit your post and add your additional comments. And PLEASE edit your first post and put the

 tags around your code.  You'll get a little more respect on these boards if you do.  If you don't know how, read the guidelines at the top of each forum for some good advice.

vaaaska, actually these boards ARE here for more experienced users to help those less capable.  It's how we learn.  These very forums are what helped ME to learn PHP, and I am more than happy to return the favor.  Sometimes you just can't figure out the solution, even when it's staring you in the face, and it takes someone else to point it out.

Incidentally, "???" is not help.  Tez has asked politely for help, and your posts came off a little bit arrogant.  If you don't want to help, that's fine, but I'm sure there are people here that would be happy to.

We have all done stupid things in our code that someone else has pointed out.  Nothing wrong with a bit of ribbing, but let's try to get this board back to being a bit more helpful, and a little less condescending.  I would hate for PHPBuilder to start getting a bad reputation.

[ahundiak]

Once you get past your connectivity issues you might try changing:
WHERE 'coursecode' = '$coursecode'"
To
WHERE coursecode = '$coursecode'"
Field names do not need quote marks.

And pull this out of the $sql string:
or die (mysql_error().'<hr /><pre>'.$sql.'</pre>'

[vaaaska]

Buzzly...this is not the first time this code has been posted. We have already tried fixing this piece of code...there is a history here which is why I've suggested he do some reading.

[BuzzLY]

Ah. I see.