Update problem.Can someone help me?Please..

[duelist]

I'm currently encounter the problem regarding on updating the data in mysql.I'm using this code,but it always clearing the data instead.Here the code:

<?php
$childID = $_GET[childID];

//Connect to database

 $query = "UPDATE staff_children SET child_name = '$child_name', child_edu = '$child_edu', child_age = '$child_age' WHERE childID = '$childID'"; 

$result = mysql_query($query);
echo "<script languange = 'Javascript'>
		alert('Your changed had been save');
		location.href = 'StaffFamilyView.php';
		</SCRIPT>";

?>

I can't figure out whats wrong,can someone help me.

Thank you in advance.

Regard,
Khairi.

[devinemke]

1. you are never setting the $child_name, $child_name, $child_age variables
2. echo the query before running it to see it it contains the intended values
3. use [man]mysql_error[/man] while debugging