I have put your eksampel in update_ac.php and then i get ERROR.


<?php
$host="localhost"; // Host name
$username="xx"; // Mysql username
$password="xx"; // Mysql password
$db_name="xx"; // Database name
$tbl_name="test_mysql"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// update data in mysql database
$sql = "UPDATE " . mysql_real_escape_string($tbl_name) .
" SET name=\'" . mysql_real_escape_string($name) .
"\', lastname=\'" . mysql_real_escape_string($lastname) .
"\', email=\'" . mysql_real_escape_string($email) .
"\' WHERE id=\'" . mysql_real_escape_string($id) . "\'";

// if successfully updated.
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}

else {
echo "ERROR";
}

?>