open page

open page

Dear All

Using PHP A record is displayed.
and same can be deleted using JQUERY

But after deleting the record i want to show next record

JQUERY code to check whether a record is deleted
 
  1. $("#deleterecordy").click(function () {
  2.    
  3.    $('#searchdiv').hide();    
  4.    $('#headerdiv').hide(1000);
  5.    $('#selectheaderdiv').hide(1000); 
  6.    $('#showdetails').hide(1000); 

  8.    var url = "deleterecord.php"
  9.    var data = { 
  10.  recordid:$('#recordid').val()
  11.     };

  13. $('#deleterecorddiv').load(url,data,function(data){ if (data=="1"){
  14. alert(data); }   
  15.     });
  16. });      
PHP code to delete record ( deleterecord.php)
which passes the record id of the next record to be displayed

I want to display the record of this id (passed on by deleterecord.php) in place id deleted record

Pls help

  1.  $id=$_REQUEST['recordid'];
  2. $query= sprintf("SELECT * FROM address where id=%d  ",$id) ; // Read table addrees
  3.    mysql_select_db($database_DBconnect, $DBconnect);
  4.   $Result = mysql_query($query, $DBconnect) or die(mysql_error());
  5. $rows = mysql_fetch_assoc($Result);
  6. $totalrows=mysql_num_rows($Result);
  7. // deleting images 

  9.  @unlink("../".$_POST['oldactualimage']); 
  10. @unlink("../".$_POST['oldtinyimage']); 
  11. @unlink("../".$_POST['oldsmallimage']); 
  12. @unlink("../".$_POST['oldbigimage']);
  13. @unlink("../".$_POST['oldsmallwimage']); 
  14. @unlink("../".$_POST['oldbigwimage']);
  16.  // deleting record 
  17. $del=sprintf("delete from address where id=%d",$id);
  18.   mysql_select_db($database_DBconnect, $DBconnect);
  19. $del_result = mysql_query($del, $DBconnect) or die(mysql_error());
  20.  
  21.   if($del_result){
  22.  
  23.    $nquery= sprintf("SELECT * FROM address where id>%d  ",$id) ; // Read next record
  24.    mysql_select_db($database_DBconnect, $DBconnect);
  25.   $nResult = mysql_query($nquery, $DBconnect) or die(mysql_error());
  26. $nrows = mysql_fetch_assoc($nResult);
  27. $ntotalrows=mysql_num_rows($nResult);
  28.     echo $nrows['id']; // passing value of next record
  29.   }