Update or Delete Link?

[saidbakr]

When extracted records from a data base is displayed. I found in some applications (next to the record) a link called update or delete. I know this to make change on this record. So How can I implement the sql code to be executed by clicking on this link? and is there a way to redisply the same page with the modified record after modification?
i.e page1
Name Job Salary
Record: John driver 2000$ update

So I want after click the udate link, and insert the new data, say, salary will becomes 2500, page1 will redisplayed with the updated data.
Regards:p :mad:

[swon]

Use something like this:

<a href="yoursite.php?action=update&id=<?=$id;?>">update</a>

<?
if(isset($action))
{
//your sql statement .... where id = $id;
//your sql statement with select ...... where id = $id;
}

?>

[volleytotal_ch]

i would do it the following way:

1. rewrite the link
   ... href="your_script.php?mode=change&uid=user_id" ...

2. at the beginning of this script add the code

   <?
     if(strcmpt($do,"update")==0)
     {
        // Update users salary:
        $query = "UPDATE table SET salary='".$new_salary."' WHERE userID = '".$uid."'";
        // Execute query
     }
   
   
     if(strcmp($mode,"change")==0)
     {
        // Display a form to update the user's salary (or anything else)
   ?>
        <form ...>
           <input type="hidden" name="do" value="update">
           <input type="hidden" name="uid" value="<?=$uid;?>">
           <input type="text" name="new_salary" value="">
           <input type="Submit" value="change salary">
       </form>
   <?
     }
     else
     {
        // display the normal content of the page (as you have so far)
     }
   ?>