");
}
//Update Data
$query = "UPDATE new_table SET name = 'ghi' where productno = 25000" ;
$result = mysql_query($query);
//Get Data 2
print("
");
$query = "SELECT productno, name FROM new_table";
$result = mysql_query($query);
while($recRow = mysql_fetch_array($result)){
print($recRow[0]);
print($recRow[1] ."
");
}
//Delete Record
$query = "DELETE FROM new_table WHERE productno = 25000";
$result = mysql_query($query);
//Get Data 3
print("
");
$query = "SELECT productno, name FROM new_table";
$result = mysql_query($query);
while($recRow = mysql_fetch_array($result)){
print($recRow[0]);
print($recRow[1] ."
");
}
//Drop DB
mysql_drop_db('new_db');
?>