plz help me in to write MySql Update Statement

soniya_shah_1

I have a html Form page like this;

</body>
</html>

what should be the MySql Upadate coding of update.php page ?

these are the details:

connection:- localhost

username:- abc_def

password:- 123_345

database name:- abc_client

table name :- person

table fields:- FirstName, LastName, Age

FirstName:- John

LastName:- Smith

Age:- 24

the coding should update the Age field where FirstName is John and

LastName is Smith.

krotkruton

First things first, please surround your code with php tags so it is easier to read. You can select a block of code and hit the php button to do this, or enter them manually. You'll get more responses this way.

Second, this is a really really basic question, and with a little research on your own, you probably could have found the answer (google "mysql update").

Finally, it's hard to answer if we don't know where you have the first and last names set. I'm going to assume you have some way to get them into a variable on your update.php page, but I'll set them explicitly. You'd basically do something like this for update.php:

$first = "John";
$last = "Smith";
//check to make sure the user submitted something
if (isset($_POST['age'])) {
  //check to make sure a value was submitted for age
  if ($_POST['age'] != "") {
    // DO - connect to database
    $query = "UPDATE person SET Age = '$_POST['age']' WHERE FirstName = '$first' AND LastName = '$last'";
    // DO - execute query
    echo "Age has been updated";
  } else {
  echo "You must enter a value for age";
  }
} else {
  echo "You have reached this page without submitting a form";
}

I haven't tested it so I don't know if there are any errors, but it's pretty simple. Also, this code doesn't check to see that age is a number, so you'll need to check for that too. Hopefully that gets you started.