Create table feedback (fid int(3),name varchar2(30),email varchar(20),subject varchar(30),satatus enum('0','1')); UPDATE feedback SET status =
CASE
WHEN 1 THEN 0
WHEN 0 THEN 1
END
WHERE fid = 3; SELECT CASE is_status
WHEN 1 THEN 'Replied'
WHEN 0 THEN 'Not Replied'
END AS 'fstatus'
FROM feedback;<body>
<script language="JavaScript">
function setDisplay(id,attribute){
document.getElementById(id).style.display = attribute;
}
</script>
<div id="register" style="display: block;">
<input onclick="setDisplay('myform', 'block');setDisplay('register', 'none');" type="button" value="Register Now" />
</div>
<div id="myform" style="display: none;">
<table>
<tr>
<td>Userid:</td>
<td><input name="userid" TYPE="text" SIZE="20" MAXLENGTH="20"></td>
</tr>
<tr>
<td>Password:</td>
<td><input name="password" TYPE="password" SIZE="20" MAXLENGTH="20"></td>
</tr>
<tr>
<td>Name:</td>
<td><input name="name" TYPE="text" SIZE="30" MAXLENGTH="30"></td>
</tr>
<tr>
<td>Email:</td>
<td><input name="email" TYPE="text" SIZE="50" MAXLENGTH="50"></td></tr>
</table>
<input onclick="setDisplay('myform', 'none');setDisplay('register', 'block');" type="button" value="Go Back" />
</div>
</body>
</html>
