I can not edit a field in my database

Question

I have a problem I can not edit the field birthdate in my database .I need help please. this is the code.employees.php

    $Nom = mysql_real_escape_string($_POST["nom"]);
    $Id = mysql_real_escape_string($_POST["id"]);
    $Prenom = mysql_real_escape_string($_POST["prenom"]);
    $BirthDate = mysql_real_escape_string($_POST["birthdate"]);
    $rs = mysql_query(" UPDATE users SET nom = '" .$Nom ."', prenom = '" .$Prenom ."', birtdate = '" .$BirthDate."' WHERE id = " .$Id) or die(mysql_error());
    echo json_encode($rs);

Welcome to Stack Overflow! [Please, don't use `mysql_*` functions](http://stackoverflow.com/q/12859942/1190388) in new code. They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). See the red box? Learn about prepared statements instead, and use [tag:PDO] or [tag:MySQLi]. — hjpotter92, May 12 '13 at 12:14

Moak · Answer 1 · 2013-05-12T12:27:40.143

2

Your query is referencing a field named birtdate, which according to your question and the spelling in the rest of your code should be birthdate

$rs = mysql_query("UPDATE users SET nom = '" .$Nom ."', prenom = '" .$Prenom ."', birthdate = '" .$BirthDate."' WHERE id = " .$Id) or die(mysql_error());

edited May 12 '13 at 12:27

answered May 12 '13 at 12:14

Moak

12,596
27
111
166

it should be a comment if u are guessing the mistake – M Khalid Junaid May 12 '13 at 12:19
@dianuj Everything seems correct, he says "can not edit the field ***birthdate***" with the value from the `$_POST["birthdate"]` yet his SQL says `birtdate =` – Moak May 12 '13 at 12:21
1

good catch +1 for you – M Khalid Junaid May 12 '13 at 12:23
i don't have error this is my index.html ` – user2374778 May 12 '13 at 13:38

I can not edit a field in my database

1 Answers1