Code: Select all
//GET THE TOTAL OF LEVEL 2
$result = mysql_query("SELECT COUNT(*) FROM agents WHERE (sponsor = '1' or sponsor = '2' or sponsor = '3') LIMIT 0,1")or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$lvl2parent = $row['COUNT(*)'];
echo "<b>Total Level 2 </b> : ";
echo "$lvl2parent <br><br>";Hope you can help me. this is the final function to finish my project. Thanks!