Crystal Added with id : $id";
}
else {
$query= "UPDATE crystals SET
`name`='$new_name',
`formula`='$new_formula',
`description`='$new_description',
`sgnum` = '$new_sgnum',
`atoms` = '$new_atoms'
WHERE `id` = '$id'";
$result=mysql_query($query) or die(mysql_error());
echo "
Changes Made to : $id
";
}
mysql_close();
}
else
{
echo "
Make Changes to :
";
$id = $_GET['id'];
}
if ($_GET['action'] == "new")
{
echo "
Make New Crystal
";
$id = "new";
}
if ($_GET['action'] != "new")
{
$username="www";
mysql_connect(localhost,$username);
@mysql_select_db($database) or die( "Unable to select database");
$query= "SELECT * FROM crystals WHERE id=$id";
$result=mysql_query($query);
$current_name = mysql_result($result,0,"name");
$current_formula = mysql_result($result,0,"formula");
$current_description = mysql_result($result,0,"description");
$current_sgnum = mysql_result($result,0,"sgnum");
$current_atoms = mysql_result($result,0,"atoms");
mysql_close();
}
?>
[View Crystal]