Home --- Topics --- Articles --- Offers --- Register --- Contact us

Did you know?

if you register at Hamid School you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!

Are you Confused? Click here to learn how to use hamid school

PHP MySQL Update

The UPDATE statement is used to modify data in a database table.

Update Data In a Database

The UPDATE statement is used to modify data in a database table.

Syntax

UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value

Note: SQL statements are not case sensitive. UPDATE is the same as update.

To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.

Example

Earlier in the tutorial we created a table named "Person". Here is how it looks:

FirstName	LastName	Age
Peter	Griffin	35
Glenn	Quagmire	33

The following example updates some data in the "Person" table:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

mysql_query("UPDATE Person SET Age = '36'
WHERE FirstName = 'Peter' AND LastName = 'Griffin'");

mysql_close($con);
?>

After the update, the "Person" table will look like this:

FirstName	LastName	Age
Peter	Griffin	36
Glenn	Quagmire	33

Viewed:326

15-Jul-2008
Related articles:

Did you know?

if you register at Hamid School you can learn web programming and designing for free and also you can save up to 45% on hosting packages offered by Surreyhost.com .

Don't miss out, every minute counts!