bahi ye mein ap ko khud sara bana ker de deta lakein abhi ap ko bhi jaldi ha or mein bhi es time position mein nai hon k ap ko bana k don ap updation or delaetion k liye fil hal es ko follow karo ,,,,
if ( $type == "Update") {
$query = "UPDATE GUEST SET "
. "F_NAME = '" . $fn
. "', L_NAME = '" . $ln
. "', STR_ADDRESS = '" . $ad
. "', CITY = '" . $ct
. "', STATE = '" . $st
. "', ZIP = " . $zp
. ", COUNTRY = '" . $cn
. "', PHONE_Num = '" . $ph
. "' WHERE GUEST_ID = " . $id;
}
if ( $type == "Add") {
$query = "INSERT INTO GUEST "
. "(F_NAME, L_NAME, STR_ADDRESS, "
. "CITY, STATE, ZIP, COUNTRY, PHONE_Num)"
. " VALUES ("
. "'" . $fn . "', '" . $ln
. "', '" . $ad . "', '" . $ct
. "', '" . $st . "', " . $zp
. ", '" . $cn . "', '" . $ph . "')";
}
if ( $type == "Delete") {
$query = "DELETE FROM GUEST WHERE GUEST_ID = " . $id;
}
echo $query;
if ($conn && $query != "") {
$result = mysql_query($query,$conn);
}
?>
Bookmarks