PHP&MySql

[ray-solomon]

I am still trying to get this script working after modifying it 22 times. The point is getting the script to verify that the logged in member has reffered my website to 2 other people, and those two people signed up. If those 2 people did not signup then the member cannot go to a special link. I use PHP4 & MySql. Please Help

<?
  session_start();

  // check session variable

  if (session_is_registered("valid_user"))
  {

        include "../config.php";

        mysql_connect("$server", "$db_user", "$db_pass");
        mysql_select_db("$database");


{

}
      $result = mysql_query("SELECT * FROM clickthroughs where refid = '$valid_user'") or die ("Database Error");
   {         if(mysql_num_rows(mysql_query('result'>2)

        print("Yes");

}          if(mysql_num_rows(mysql_query('result'<2)

         print("No");

  }}
            else
  {

        echo "<p>You have to be a member to view this page</p>";
  }

        include "footer.290";

?>

[blindeddie]

you said in the post that the membersmust have 2 refferals, but in the following if statement there is a syntax error as well as a conditional error...

if(mysql_num_rows(mysql_query('result'>2)

        print("Yes");

}

try changing that to

if(mysql_num_rows($result') >= 2) {

        print("Yes");

}

AND...

if(mysql_num_rows(mysql_query('result'<2)

         print("No");

to...
if(mysql_num_rows($result') < 2) {

        print("No");

}

this should fix the problem..... Hope it helps...

[ray-solomon]

Thankyou, but i have it figured out already.