NYCPHP Meetup

[nycphp-talk] Need help with Updating data in MySQL

Subson Mittal subson at gmail.com
Fri Jun 30 07:51:44 EDT 2006


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<http://us.rd.yahoo.com/evt=40762/*http://www.yahoo.com/preview>.
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20060630/761d65e8/attachment.html>


More information about the talk mailing list