Jump to content


Photo

Active Pending


  • Please log in to reply
No replies to this topic

#1 omesa

omesa
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 26 October 2006 - 08:56 AM

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

$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'");
           
         }

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

any help would be greatly appreciated.
regards
clement




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users