Mysql php update function problem

Question

How do I create a php code for mysql to do the fallowing?

if active = 1 to do current amount + 2000

id,   eid,       amount,   apply 1,  apply 2,      apply 3,  active
1     1788       500        NULL        NULL        NULL      1
2     1956       1000       NULL        NULL        NULL      1
3     2035       1500       NULL        NULL        NULL      1

And the output to be like this nothing else to change.

id,   eid,       amount,   apply 1,  apply 2,      apply 3,  active
1     1788       2500       NULL        NULL        NULL      1
2     1956       3000       NULL        NULL        NULL      1
3     2035       3500       NULL        NULL        NULL      1

Thanks in front for people who will help

so you want the amount + 200? and your example dictates 500+200=2500? Whats going on? — NDM
– NDM, Commented Dec 1, 2009 at 11:47
don't forget to tick the answer that helped you resolve your issue! :) hint hint! — Shadi Almosri
– Shadi Almosri, Commented Dec 1, 2009 at 18:01

Ben James · Accepted Answer · 2009-12-01 11:46:40Z

2

The SQL query is as follows:

UPDATE tablename SET amount=amount+2000 WHERE active=1;

How you execute this in PHP depends on which database driver you're using.

For example, using mysqli:

<?php
$link = mysqli_init();
mysql_real_connect($link, $host, $username, $password, $db_name);
mysqli_query($link, "UPDATE tablename SET amount=amount+2000 WHERE active=1");

answered Dec 1, 2009 at 11:46

Ben James

126k27 gold badges196 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shadi Almosri · Accepted Answer · 2009-12-01 12:11:46Z

0

<?php
    $host = "host";
    $username= "username";
    $password= "password";
    $db_name= "db_name";
    $link = mysql_connect($host, $username, $password);
    mysql_select_db($db_name, $link);
    mysql_query("UPDATE tablename SET amount=amount+2000 WHERE active=1");
?>

answered Dec 1, 2009 at 12:11

Shadi Almosri

12k16 gold badges62 silver badges80 bronze badges

Collectives™ on Stack Overflow

Mysql php update function problem

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related