Re: How to update info in the database

Try this, for update a database > if ($Submit) { $GetDeductionDetailQuery = "Update DESCRIPTION,AMOUNT,BALANCE,COMPULSORY FROM ADMCLIDEDUCTION where CLIENTNO='ADM108'"; $GetDeductionDetailQuery_Result = ibase_query($GetDeductionDetailQuery,$connection) or die ("Couldn't execute query"); <input type="text" name="DESCRIPTION" > <input type="text" name="AMOUNT" > <input type="text" name="BALANCE" > <input type="text" name="COMPULSORY " > <input type="submit" name="Submit" value="Submit"> Al the variables in the submit are de values in the datbase. Nos vemos, Isabel Fàbregas ----------------------------------------------- ifabregas@worldonline.es World Online, S.A. Telèfon 93 225 73 50 Ext. 228 ----- Original Message ----- From: "Sonya Davey / QDCEL" <SonyaD@PQAfrica.co.za> To: <php-general@lists.php.net> Sent: Wednesday, November 15, 2000 1:02 PM Subject: [PHP] How to update info in the database > Hi, can anyone help me with the syntax for updating info to the database. > > This is what I have with a select statement, how do I change it to do an > update? > > if ($Submit) > { > $GetDeductionDetailQuery = "SELECT DESCRIPTION,AMOUNT,BALANCE,COMPULSORY > FROM ADMCLIDEDUCTION > where CLIENTNO='ADM108'"; > $GetDeductionDetailQuery_Result = > ibase_query($GetDeductionDetailQuery,$connection) > or die ("Couldn't execute query"); > <input type="text" name="text1" > > <input type="text" name="text2" > > <input type="text" name="text3" > > <input type="text" name="text4" > > <input type="submit" name="Submit" value="Submit"> > > etc. > > Thanks in advance! > Sonya > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >