Query update database
uery update is used for edit value in database
This is value at database reseller that we have insert first.
- field username with value johnson
- field passwd with value johnson$32#
- field name with value Johnson Gunawan
- field email with value Johnson@yahoo.com
After insert data to database, if want to edit/change value we can use :
mysql_query( ”
update database_name
set query that will execute
“) or error( mysql_error() );
don’t forget “” inside ( )
mysql_query(”
update reseller set
passwd = ‘$_POST[nama_bank]’,
name = ‘$_POST[no_rekening]’,
email = ‘$_POST[an_rekening]’
where username = ‘$_GET[username]’
“) or error( mysql_error() );
Example at php
We want to change
- passwd from johnson$32# to johnson21
- name from Johnson Gunawan to Johnson G.
- email from Johnson@yahoo.com to johnson@gmail.com
we can use this code :
mysql_query( ”
update reseller set
passwd = ‘johnson21’,
name = ‘Johnson G.’,
email = ‘johnson@gmail.com’
where username = ‘johnson’
”) or error( mysql_error() );
Related post :