[nycphp-talk] Need help with Updating data in MySQL
Karl Brian Dano
karl_niarb at yahoo.com
Fri Jun 30 20:30:46 EDT 2006
Oh, great! :D Thanks! :D So basically, you just put <field>+<the value?> after the SET? Alright, thanks again! :D
Subson Mittal <subson at gmail.com> wrote: Hello Karl,
you can write the query in mysql
update table <table name> set number = number+50 where <where condition >
Thanks
Subson
On 6/30/06, Karl Brian Dano <karl_niarb at yahoo.com> wrote: Hello Everyone,
I need help with updating an existing data in MySQL through PHP. I want to add a certain amount to an already existing data in a field. For example, in a field called "numbers", in that record, there's already a value of "500". I want to know how I can add "50" to that record so that it becomes "550".
Help will be greatly appreciated.
---------------------------------
Sneak preview the all-new Yahoo.com. It's not radically different. Just radically better.
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
New York PHP Conference and Expo 2006
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
--
Thanks
Subson Mittal _______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
New York PHP Conference and Expo 2006
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
---------------------------------
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail Beta.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20060630/02190836/attachment.html>
More information about the talk
mailing list