Jump to content

Archived

This topic is now archived and is closed to further replies.

omesa

Active Pending

Recommended Posts

Hello,
I had posted earlier on a system am working on I got stuck earlier on but I managed to correct the error, now am stuck again.
I want to insert into my database the value "Active" if the points are less than 10, otherwise update the database with "Pending" value if the points are greater than 10, as in;

MPoints MStatus
9 Active
10 Active
11 Pending
12 Pending

Here's the code am currently using, it inserts into two rows, where the results are something like
MPoints MStatus
9
0 Active
10
0 Active
11
0 Active

[code]
$upoints = mysql_query("update members set MPoints = MPoints+1");
        $result2 = mysql_query("SELECT mpoints,mstatus FROM members WHERE id = '$id'");
        if (mysql_num_rows($result2) <= 10)
          { # not found
          $result = mysql_query("INSERT INTO members (mstatus) VALUES ('Active')");
         
          }
        else
        {
          $result = mysql_query("UPDATE members SET mstatus = 'Pending' WHERE id = '$id'");
         
        }
[/code]

How do I achieve this:
MPoints MStatus
9 Active
10 Active
11 Pending
12 Pending

any help would be greatly appreciated.
regards
clement

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.