modify record

Anon

Hi boy,hi girl,
i'd like have your helps...
first of all sorry for my english it isn't so perfect....second i would know how i can modify record in a table of my database...if one of you have some examples code please write me!!
Thank u for your aid....i hope in u!!;-D
Fefo

Anon

To update a table called order, where the order number is 3 and you want to set the processed field to YES :-

Using PHP you would use something like :-
$result = mysql_query("update orders set processed=\"YES\" where orderid='3'");

If you want to use the command line for MySQL :-

mysql -u root -p databasename
update orders set processed='YES' where orderid='3';

I hope that helps (And I haven't included a typo)

Regards
Darren

Hosting from $4.80/£3 pm

HTTP://WWW.PHP3HOSTING.COM ($)
HTTP://WWW.PHP3HOSTING.CO.UK (£)
PHP3/4, MySQL, Full CGI-BIN