MySQL Update

The UPDATE statement is used to update existing records in a table.
Syntax:
1
2
3
4
5
UPDATE table_name
 
SET column1=value, column2=value2,...
 
WHERE some_column=some_value
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.
For example, the following example updates some data in the "Persons" table:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("my_db", $con);
 
mysql_query("UPDATE Persons SET Age = '36'
WHERE FirstName = 'Peter' AND LastName = 'Griffin'");
 
mysql_close($con);
?>
MySQL Where
MySQL Order By
MySQL Delete
XML Expat Parser