Code: Select all
$showwebtwo = MYSQL_QUERY("SELECT * FROM web");
while ($row = mysql_fetch_assoc($showwebtwo)) {
$idweb = $row['id'];
$clientid = $row['clientid'];
$url = $row['url'];
$domaincompany = $row['domaincompany'];
$domainexp = $row['domainexp'];
$domainuser = $row['domainuser'];
$domainpass = $row['domainpass'];
$domainregkey = $row['domainregkey'];
$hostcompany = $row['hostcompany'];
$hostexp = $row['hostexp'];
$hostuser = $row['hostuser'];
$hostpass = $row['hostpass'];
$hostpackage = $row['hostpackage'];
$onlinewhatone = $row['onlinewhatone'];
$onlineuserone = $row['onlineuserone'];
$onlinepassone = $row['onlinepassone'];
$onlinewhattwo = $row['onlinewhattwo'];
$onlineusertwo = $row['onlineusertwo'];
$onlinepasstwo = $row['onlinepasstwo'];
$onlinewhatthree = $row['onlinewhatthree'];
$onlineuserthree = $row['onlineuserthree'];
$onlinepassthree = $row['onlinepassthree'];
$emailuserone = $row['emailuserone'];
$emailpassone = $row['emailpassone'];
$emailusertwo = $row['emailusertwo'];
$emailpasstwo = $row['emailpasstwo'];
$emailuserthree = $row['emailuserthree'];
$emailpassthree = $row['emailpassthree'];
$emailuserfour = $row['emailuserfour'];
$emailpassfour = $row['emailpassfour'];
$emailuserfive = $row['emailuserfive'];
$emailpassfive = $row['emailpassfive'];
$emailusersix = $row['emailusersix'];
$emailpasssix = $row['emailpasssix'];
$emailuserseven = $row['emailuserseven'];
$emailpassseven = $row['emailpassseven'];
$emailusereight = $row['emailusereight'];
$emailpasseight = $row['emailpasseight'];
$emailusernine = $row['emailusernine'];
$emailpassnine = $row['emailpassnine'];
$emailuserten = $row['emailuserten'];
$emailpassten = $row['emailpassten'];
$emailusereleven = $row['emailusereleven'];
$emailpasseleven = $row['emailpasseleven'];
$emailusertwelve = $row['emailusertwelve'];
$emailpasstwelve = $row['emailpasstwelve'];
$emailuserthirteen = $row['emailuserthirteen'];
$emailpassthirteen = $row['emailpassthirteen'];
$emailuserfourteen = $row['emailuserfourteen'];
$emailpassfourteen = $row['emailpassfourteen'];
$emailuserfifteen = $row['emailuserfifteen'];
$emailpassfifteen = $row['emailpassfifteen'];
$emailusersixteen = $row['emailusersixteen'];
$emailpasssixteen = $row['emailpasssixteen'];
$emailuserseventeen = $row['emailuserseventeen'];
$emailpassseventeen = $row['emailpassseventeen'];
$emailusereighteen = $row['emailusereighteen'];
$emailpasseighteen = $row['emailpasseighteen'];
$emailusernineteen = $row['emailusernineteen'];
$emailpassnineteen = $row['emailpassnineteen'];
$emailusertwenty = $row['emailusertwenty'];
$emailpasstwenty = $row['emailpasstwenty'];
$emailusertwentyone = $row['emailusertwentyone'];
$emailpasstwentyone = $row['emailpasstwentyone'];
$emailusertwentytwo = $row['emailusertwentytwo'];
$emailpasstwentytwo = $row['emailpasstwentytwo'];
$emailusertwentythree = $row['emailusertwentythree'];
$emailpasstwentythree = $row['emailpasstwentythree'];
$emailusertwentyfour = $row['emailusertwentyfour'];
$emailpasstwentyfour = $row['emailpasstwentyfour'];
$emailusertwentyfive = $row['emailusertwentyfive'];
$emailpasstwentyfive = $row['emailpasstwentyfive'];
$emailusertwentysix = $row['emailusertwentysix'];
$emailpasstwentysix = $row['emailpasstwentysix'];
$emailusertwentyseven = $row['emailusertwentyseven'];
$emailpasstwentyseven = $row['emailpasstwentyseven'];
$webcomments = $row['webcomments'];
$tenday = $row['tenday'];
$recieved = $row['recieved'];
$updatecomments = $row['updatecomments'];
$invno = $row['invno'];
echo $url;
$showwebtwo = MYSQL_QUERY("SELECT clientname FROM clients WHERE id = '$clientid'");
while ($row = mysql_fetch_assoc($showwebtwo)) {
$clientname = $row['clientname'];
}
echo $clientname;
$currentday = date("d");
$currentmonth = date("m");
$currentyear = date("y");
$domhost = "";
$domainexpiry = $domainexp;
list($dday, $dmonth, $dyear) = split('[/.-]', $domainexpiry);
if ((($dmonth == $currentmonth + 1) && ($dyear == $currentyear)) || (($dmonth == $currentmonth) && ($dday > $currentday) && ($dyear == $currentyear))){
$domhost = "<b>Domain</b>";
$d = $dday;
$m = $dmonth;
$y = $dyear;
}
$hostexpiry = $hostexp;
list($hday, $hmonth, $hyear) = split('[/.-]', $hostexpiry);
if ((($hmonth == $currentmonth + 1) && ($hyear == $currentyear)) || (($hmonth == $currentmonth) && ($hday > $currentday) && ($hyear == $currentyear))){
$domhost = "<b>Hosting</b>";
$d = $hday;
$m = $hmonth;
$y = $hyear;
}
if (!empty($domhost)) { ?>
<tr>
<td width="12.5%" height="20" align="center"><? echo $clientname; ?></td>
<td width="12.5%" height="20" align="center"><? echo $url; ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Domain</b>"){ echo $domaincompany; } else { ?> <? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Domain</b>"){ echo $domainexp; } else { ?> <? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Hosting</b>"){ echo $hostcompany; } else { ?> <? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Hosting</b>"){ $hostexp; } else { ?> <? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Hosting</b>"){ $hostpackage; } else { ?> <? } ?></td>
<td width="12.5%" height="20" align="center"> </td>
</tr>
<?
}
}