# Update database script

**URL:** <https://forum.kirupa.com/t/update-database-script/308260>\
**Category:** Uncategorized\
**Created:** [April 20, 2010, 10:14am UTC](https://forum.kirupa.com/t/update-database-script/308260 "2010-04-20T10:14:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pucca](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@pucca](https://forum.kirupa.com/u/pucca)\
**Post date:** [April 20, 2010, 10:14am UTC](https://forum.kirupa.com/t/update-database-script/308260/1 "2010-04-20T10:14:00Z")

</div>

hi. for some reason I can get this to work. I’m not a php/sql guru.  
Please can someone help?  
The way I did this, is obviously a very long way, and wrong way…Have a look at my code. I’ve got 3 different queries on one page. and 3 different submit buttons to run them. I would like ONE submit button and hopefully ONE query to update the fields.  
at the moment, when I update for example the first one, it updates on the DB, but the amount showing in the field, returns to the old amount.  
Hope this is clear. Please help :ponder:

```auto
<?php 
$db_connect = mysql_connect("server", "db", "un");
//Pick the database to use
mysql_select_db("db_name", $db_connect);
$sql1 = "Select * from markets WHERE id = 1";
$rsmarkets1 = mysql_query($sql1,$db_connect);
$rows1 = mysql_fetch_assoc($rsmarkets1);

$sql2 = "Select * from markets WHERE id = 2";
$rsmarkets2 = mysql_query($sql2,$db_connect);
$rows2 = mysql_fetch_assoc($rsmarkets2);

$sql3 = "Select * from markets WHERE id = 3";
$rsmarkets3 = mysql_query($sql3,$db_connect);
$rows3 = mysql_fetch_assoc($rsmarkets3);
?>
<?php 

    if (isset($_REQUEST['btnupdate1'])) {
    
        $amount = $_REQUEST["amount1"];
        
    $update = "Update markets set amount =" . $amount . " where id = 1";    
    $execute = mysql_query($update,$db_connect);

}

    if (isset($_REQUEST['btnupdate2'])) {
    
        $amount = $_REQUEST["amount2"];
        
    $update = "Update markets set amount =" . $amount . " where id = 2";    
    $execute = mysql_query($update,$db_connect);

}
    if (isset($_REQUEST['btnupdate3'])) {
    
        $amount = $_REQUEST["amount3"];
        
    $update = "Update markets set amount =" . $amount . " where id = 3";    
    $execute = mysql_query($update,$db_connect);

}
?>
 <form name="form1" method="post" action="<?php $_SERVER['PHP_SELF'];?>?id=1">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td align="left" width="50%"><?php echo $rows1['name'];?></td>
    <td align="left" width="30%"><input name="amount1" type="text" id="amount1" value="<?php echo $rows1['amount'];?>"></td>
    <td align="right" width="20%">            
              <input type="submit" name="btnupdate1" value="" id="submit" class="update_form_submit">
    </td>    
  </tr>
  </table>
        </form>
 <form name="form2" method="post" action="<?php $_SERVER['PHP_SELF'];?>?id=2">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td align="left" width="50%"><?php echo $rows2['name'];?></td>
    <td align="left" width="30%"><input name="amount2" type="text" id="amount1" value="<?php echo $rows2['amount'];?>"></td>
    <td align="right" width="20%">            
              <input type="submit" name="btnupdate2" value="" id="submit" class="update_form_submit">
    </td>    
  </tr>
  </table>
        </form>      
 <form name="form3" method="post" action="<?php $_SERVER['PHP_SELF'];?>?id=3">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td align="left" width="50%"><?php echo $rows3['name'];?></td>
    <td align="left" width="30%"><input name="amount3" type="text" id="amount3" value="<?php echo $rows3['amount'];?>"></td>
    <td align="right" width="20%" valign="middle">            
              <input type="submit" name="btnupdate3" value="" id="submit" class="update_form_submit">
    </td>    
  </tr>
  </table>
        </form>     
<?php
mysql_free_result($rsmarkets1);
mysql_free_result($rsmarkets2);
mysql_free_result($rsmarkets3);
mysql_close($db_connect);
?>  

```