eunicewt

Hi,   I have this error and I know it is an empty string but I cannot find where is my mistake. Anyone can tell me where is my mistake. My coding   // update asset                         $sql = "UPDATE Assets SET financetag='" . $assettype_id  . $assettag . "',assettype='" . $assettype . "',assetsupplier='" . $assetsupplier . "',assetmodel='" . $assetmodel . "',assetserial='" . $assetserial . "',assetprice='" . $assetprice .  "',description='" . $assetdescription . "',make='" . $assetmake . "',year='" . $assetyear . "',rego='" . $assetrego . "',notes='" .  $notes . "' WHERE id=" . $key . ";";                         if ($result = doSql($sql)) { An error occurred while attempting to update the database. Please contact the webmaster. This is action attempted:: INSERT INTO Assets (financetag,assettype,assetsupplier,assetmodel,assetserial,assetprice,description,make,year,rego,status,notes,added_by, date_added) VALUES ('1691751','sdsd','16','','','0','','','2006','','','', '1', '2006-07-01 15:09:11'); Duplicate entry '' for key 2 Eunice

Anyone can tell me how to extract the information from the database and send an email to the repective people? Thanks.

Hi,   It is a school project.I want to know how to send an email notification to this manager after the user has edited its profile and pressed the add button. It not only update the database but it also sends out an email to inform the manager as well? Anyone can help me? I am super stress by the codings.

Hi,     I want to know how to trigger an email to inform the manager this user has updated his profile and it was also uploaded in the database at the same time? Thanks Eunice