<? require_once("../conn.php"); require_once("access.php"); include_once("LeftStyles.php"); //get the unapproved users list $q1 = "select * from yellow_agents where AccountStatus = 'pending' order by RegDate desc "; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) == '0') { echo "<br><br><center><font color=red size=2 face=verdana><b>There are no pending agents!</b></font></center>"; exit(); } ?> <link rel="stylesheet" href="style.css" type="text/css"> <table width="90%" cellspacing="0" cellpadding="10" align="center" class="form"> <tr> <td> <div align="right"><font face="Arial, Helvetica, sans-serif" size="4"><b><font color="#FFFFFF">CLASSIFIEDS v2.0</font></b></font></div> </td> </tr> </table> <br> <table align=center width=300 cellspacing=1 cellpadding=4> <tr> <td><font color=black face=verdana size=2><b><img src="images/admin/agents.jpg" width="23" height="22" align="absmiddle"> LIST PENDING MEMBERS</b></font></td> </tr> <tr> <td class=form_answer width=200>Name</td> <td class=form_request width=100 align=center>Date</td> </tr> <? $col = "white"; while($a1 = mysql_fetch_array($r1)) { if($col == "white") { $col = "dddddd"; } else { $col = "white"; } $MyDate = date('M d Y', $a1[RegDate]); echo "<tr bgcolor=$col>\n\t<td class=form_request><a class=BlackLink href=\"ViewUser.php?AgentID=$a1[AgentID]\">$a1[FirstName] $a1[LastName]</a></td>\n\t<td class=form_answer align=center>$MyDate</td>\n</tr>\n"; } echo "</table>\n\n<br><br>\n\n"; ?>