Update Query in PHP not Updating

Update Query in PHP not Updating and no error message

[Habtom]

Hello,

I am having a hard time here trying to identify why this update query can't update the data in the database. It doesn't generate any errors too.

<?php
include("connecttodb.php");
$ordercode = $_POST['ordercode'];
$done = $_POST['done'];
$sql6 = "Update deliveryinfo set done = ". $done ." where code = ". $ordercode;
echo $sql6;
mysql_query($sql6);
mysql_close();
?>
Successfully Updated.

Connecttodb.php works fine as I use it in all the pages. What could be wrong on this code? Please help!

Habtom

[Habtom]

Thanks guys, I tried it again and I solved it.
Here is the solutions I found out.

<?php
include("connecttodb.php");
$ordercode = $_POST['ordercode'];
$done = $_POST['done'];
$sql6 = "Update deliveryinfo set done = '$done' where code = '$ordercode'";
echo $sql6;
mysql_query($sql6);
mysql_close();
?>

Habtom