Loop

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Loop

Post by iknownothing »

I don't know why but my loop won't work. Its messy I know...

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 { ?>&nbsp;<? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Domain</b>"){ echo $domainexp; } else { ?>&nbsp;<? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Hosting</b>"){ echo $hostcompany; } else { ?>&nbsp;<? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Hosting</b>"){ $hostexp; } else { ?>&nbsp;<? } ?></td>
<td width="12.5%" height="20" align="center"><? if ($domhost == "<b>Hosting</b>"){ $hostpackage; } else { ?>&nbsp;<? } ?></td>
<td width="12.5%" height="20" align="center">&nbsp;</td>
</tr>
<?	 
  	 }
  	 }
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Post by Kieran Huggins »

8O speaking of loops...

Code: Select all

foreach($row as $k=>$v{
   $$k=$v;
}
Also - you should probably have a separate table for all those usernames / passwords and then associate them with a client.

This:

Code: Select all

while ($row = mysql_fetch_assoc($showwebtwo)) {
        $clientname = $row['clientname'];
}
not only overwrites your DB result handle but also your $row variable... maybe you intended to end the first while loop before beginning the second?

I haven't even read the rest...
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

that was the problem, i needed another db call inside the original, so it works now, thanks.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Is there a reason why the email users and passwords aren't in a separate table? (Same goes for the "online" groups too)
Post Reply