php editing data from the database

[Myrnalyn]

Hi all,
i am creating an update form wherein i can view my data from the database and can perform to delete and edit data too. what should i do in order that i can edit my data and as well as save the edited data in the database.
this my code in the update form in which if i will click the save button to save the edited the data, the data will be deleted from the database it will just perform likely to my delete button.
<?php
$link=@mysql_connect("localhost","root","");
mysql_select_db("nn");

$r=$_REQUEST['r'];
if ($_REQUEST['r']!=''){

$query = "SELECT * FROM land_table where ARP_No = " . $r ;
$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_array($result) or die(mysql_error());

}
if($_REQUEST['delete']!= 'delete'){

$query="delete from land_table where ARP_No = " .$r;
mysql_query($query);

}

if ($_REQUEST['save']!= 'save'){
$ARP_No=$_REQUEST['ARP_No'];
$PIN=$_REQUEST['PIN'];
$OTC_TCT_No=$_REQUEST['OTC_TCT_No'];
$SURVEY_No=$_REQUEST['SURVEY_No'];
$OWNER=$_REQUEST['OWNER'];
$ADDRESS=$_REQUEST['ADDRESS'];
$ADMIN_OCCUPANT=$_REQUEST['ADMIN_OCCUPANT'];
$ADD=$_REQUEST['ADD'];
$No_STREET=$_REQUEST['No_STREET'];
$BRGY=$_REQUEST['BRGY'];
$MUNICIPALITY=$_REQUEST['MUNICIPALITY'];
$PROVINCE=$_REQUEST['PROVINCE'];
$NORTH=$_REQUEST['NORTH'];
$EAST=$_REQUEST['EAST'];
$SOUTH=$_REQUEST['SOUTH'];
$WEST=$_REQUEST['WEST'];
$CLASSIFICATION=$_REQUEST['CLASSIFICATION'];
$SUB_CLASS=$_REQUEST['SUB_CLASS'];
$AREA=$_REQUEST['AREA'];
$ACTUAL_USE=$_REQUEST['ACTUAL_USE'];
$UNIT_VALUE=$_REQUEST['UNIT_VALUE'];
$MARKET_VALUE=$_REQUEST['MARKET_VALUE'];
$TOTAL=$_REQUEST['TOTAL'];
$PRODUCT_CLASS=$_REQUEST['PRODUCT_CLASS'];
$AREA_PLANTED=$_REQUEST['AREA_PLANTED'];
$TOTAL_NUMBER=$_REQUEST['TOTAL_NUMBER'];
$NON_FRUIT_BEARING=$_REQUEST['NON_FRUIT_BEARING'];
$FRUIT_BEARING=$_REQUEST['FRUIT_BEARING'];
$AGE=$_REQUEST['AGE'];
$UNIT_PRICE=$_REQUEST['UNIT_PRICE'];
$MARKET_VALUE2=$_REQUEST['MARKET_VALUE2'];
$TOTAL2=$_REQUEST['TOTAL2'];
$MARKET_VALUE3=$_REQUEST['MARKET_VALUE3'];
$ADJUSTMENT_FACTOR=$_REQUEST['ADJUSTMENT_FACTOR'];
$ADJ=$_REQUEST['ADJ'];
$VALUE_ADJUSTMENT=$_REQUEST['VALUE_ADJUSTMENT'];
$ADJUSTMENT_MARKET_VALUE=$_REQUEST['ADJUSTMENT_MARKET_VALUE'];
$KIND=$_REQUEST['KIND'];
$ACTUAL_USE2=$_REQUEST['ACTUAL_USE2'];
$ADJUSTMENT_MARKET_VALUE2=$_REQUEST['ADJUSTMENT_MARKET_VALUE'];
$ASSESSMENT_LEVEL=$_REQUEST['ASSESSMENT_LEVEL'];
$ASSESSED_VALUE=$_REQUEST['ASSESSED_VALUE'];
$PREVIOUS_OWNER=$_REQUEST['PREVIOUS_OWNER'];
$TAXABILITY=$_REQUEST['TAXABILITY'];
$PREVIOUS_ASSESSED_VALUE=$_REQUEST['PREVIOUS_ASSESSED_VALUE'];
$EFFECTIVITY=$_REQUEST['EFFECTIVITY'];
$PIN_PREVIOUS=$_REQUEST['PIN_PREVIOUS'];
$PIN_PRESENT=$_REQUEST['PIN_PRESENT'];
$PIN_POSTING=$_REQUEST['PIN_POSTING'];
$TDN_PREVIOUS=$_REQUEST['TDN_PREVIOUS'];
$TDN_PRESENT=$_REQUEST['TDN_PRESENT'];
$TDN_POSTING=$_REQUEST['TDN_POSTING'];
$ROLL_PAGE_PREVIOUS=$_REQUEST['ROLL_PAGE_PREVIOUS'];
$ROLL_PAGE_PRESENT=$_REQUEST['ROLL_PAGE_PRESENT'];
$ROLL_PAGE_POSTING=$_REQUEST['ROLL_PAGE_POSTING'];

$query="UPDATE land_table SET ARP_No = '$ARP_No', PIN='$PIN', 0TC_TCT_No='$OTC_TCT_No', SURVEY_No='$SURVEY_No', OWNER='$OWNER', ADDRESS='$ADDRESS',
ADMIN_OCCUPANT='$ADMIN_OCCUPANT', ADD='$ADD', No_STREET='$No_STREET',BRGY='$BRGY', MUNICIPALITY='$MUNICIPALITY', PROVINCE='$PROVINCE', NORTH='$NORTH', EAST='$EAST', SOUTH='$SOUTH',
WEST='$WEST', CLASSIFICATION='$CLASSIFICATION', SUB_CLASS'$SUB_CLASS', AREA='$AREA', ACTUAL_USE='$ACTUAL_USE', UNIT_VALUE='$UNIT_VALUE', MARKET_VALUE='$MARKET_VALUE', TOTAL='$TOTAL', PRODUCT_CLASS='$PRODUCT_CLASS',
AREA_PLANTED='$AREA_PLANTED', TOTAL_NUMBER='$TOTAL_NUMBER', NON_FRUIT_BEARING='$NON_FRUIT_BEARING', FRUIT_BEARING='$FRUIT_BEARING', 'AGE=$AGE', UNIT_PRICE='$UNIT_PRICE', MARKET_VALUE2='$MARKET_VALUE2', MARKET_VALUE3='$MARKET_VALUE3', ADJUSTMENT_FACTOR='$ADJUSTMENT_FACTOR',
ADJ.='$ADJ.', VALUE_ADJUSTMENT='$VALUE_ADJUSTMENT', ADJUSTED_MARKET_VALUE='$ADJUSTED_MARKET_VALUE', KIND='$KIND', ACTUAL_USE='$ACTUAL_USE2', ADJUSTED_MARKET_VALUE2='$ADJUSTED_MARKET_VALUE2', ASSESSMENT_LEVEL='$ASSESSMENT_LEVEL',ASSESSED_VALUE='$ASSESSED_VALUE',
PREVIOUS_OWNER='$PREVIOUS_OWNER', TAXABILITY='$TAXABILITY', PREVIOUS_ASSESSED_VALUE='$PREVIOUS_ASSESSED_VALUE', EFFECTIVITY='$EFFECTIVITY', PIN_PREVIOUS='$PIN_PREVIOUS', PIN_PRESENT='$PIN_PRESENT', PIN_POSTING='$PIN_POSTING', TDN_PREVIOUS='$TDN_PREVIOUS', TDN_PRESENT='$TDN_PRESENT', TDN_POSTING='$TDN_POSTING',
ROLL_PAGE_PREVIOUS='$ROLL_PAGE_PREVIOUS', ROLL_PAGE_PRESENT='$ROLL_PAGE_PRESENT', ROLL_PAGE_POSTING='$ROLL_PAGE_POSTING'";

mysql_query($query);

}

?>

please help me..

[edited by: jatar_k at 3:38 pm (utc) on Mar. 12, 2008]
[edit reason] fixed sidescroll [/edit]

[httpwebwitch]

This strikes me as a question for the PHP forum. From the look of that codedump it seems like you're on the right track, but golly that's a lot of fields, and a lot of opportunities for syntax errors if you're not tidy.

This might help [webmasterworld.com]