Location: PHPKode > projects > Total ISP > total-isp/nosubs.php
<?
include "./mysql.inc.php";

$sql="SELECT CustomerID, FirstName, LastName, Reseller FROM
MasterAccounts";

$res=mysql_query($sql);

while ($row=mysql_fetch_row($res)){
	$ssql = "SELECT Login FROM SubAccounts WHERE CustomerID = $row[0]";
	$sres=mysql_query($ssql);
	if (!mysql_num_rows($sres))
		print "<A HREF=\"user.php?ID=$row[0]\"> $row[3] $row[1]
$row[2]</A><BR>";

} 
Return current item: Total ISP