RE: [PHP] How to update info in the database
| From: | Maxim Maletsky | Date: | Wed, 15 Nov 2000 12:09:55 +0000 |
| Subject: | RE: [PHP] How to update info in the database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-25418@lists.php.net to get a copy of this message | ||
$UpdateDeductionDetailQuery = "Update ADMCLIDEDUCTION set
DESCRIPTION='$DESCRIPTION',
AMOUNT='$AMOUNT',
BALANCE='$BALANCE',
COMPULSORY='$COMPULSORY'
where CLIENTNO='ADM108'";
This should be your answere.
Cheers,
Maxim Maletsky
-----Original Message-----
From: Sonya Davey / QDCEL [mailto:SonyaD@PQAfrica.co.za]
Sent: Wednesday, November 15, 2000 9:02 PM
To: 'php-general@lists.php.net'
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