I cant sort my results

mlosier

I want to sort this by username but it is not working, does anyone has any ideas why?

for($j=0;$j<sizeof($pgServices);$j++) {
						$subAcctArry = pSQLGetAssocArry("SELECT * FROM cust_svc WHERE pkgnum = '" . $curr_pkgnum . "'");
						if(sizeof($subAcctArry)>0) {
							$subAcctSvcNum = pSanitize($subAcctArry[$j]["svcnum"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM cust_svc WHERE svcnum = '" . $subAcctSvcNum . "';");
								$subAcctPkgNum = pSanitize($subAcctArry[0]["pkgnum"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM cust_pkg WHERE pkgnum = '" . $subAcctPkgNum . "' and susp is null and cancel is null;");
								$subAcctPkgPart = pSanitize($subAcctArry[0]["pkgpart"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM svc_acct WHERE svcnum = '" . $subAcctSvcNum . "' ORDER BY username ASC ;");
								$subAcctUserName = pSanitize($subAcctArry[0]["username"]);
								$subAcctTotalbytesRemaining = $subAcctArry[0]["totalbytes"] / 1048576;
								$subAcctLastLogout = pSanitize($subAcctArry[0]["last_logout"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM part_pkg_option WHERE pkgpart = '" . $subAcctPkgPart . "' AND optionname = 'totalbytes';"); 
								$subAcctTotalbytes = $subAcctArry[0]["optionvalue"] / 1048576;
							$subAcctArry = pSQLGetAssocArry("SELECT optionvalue FROM part_pkg_option WHERE pkgpart = '" . $subAcctPkgPart . "' AND optionname = 'totalbytes';");
							if(($subAcctTotalbytes == 0)) {
								if($subAcctTotalbytesRemaining > 0) {
									//some dis-parity here... Feather the benefit of the doubt and just display 
									//$subAcctTotalbytes MB of 0MB remaining... something's obviously messed up here
									$subAcctInfo .= "<li>User: <a href='" . $_SERVER["PHP_SELF"] . "?act=userinfo&reqUser=" . $subAcctUserName . "'><b>" . $subAcctUserName . "</b></a><br />\nTotal transfer remaining: " . number_format($subAcctTotalbytesRemaining, 2, ".", ",") . "MB (" . number_format($subAcctTotalbytesRemaining/1024, 2, ".", ",")  . "GB)* of <b>Unlimited</b><br />Please call your account representative to have this corrected.</li>\n";
								}else {
									$subAcctInfo .= "<li>User: <a href='" . $_SERVER["PHP_SELF"] . "?act=userinfo&reqUser=" . $subAcctUserName . "'><b>" . $subAcctUserName . "</b></a><br />\nTotal transfer remaining: <b>Unlimited</b></li>\n";
								}
							}else {
								$subAcctInfo .= "<li>User: <a href='" . $_SERVER["PHP_SELF"] . "?act=userinfo&reqUser=" . $subAcctUserName . "'><b>" . $subAcctUserName . "</b></a><br />\nTotal transfer remaining: " . number_format($subAcctTotalbytesRemaining, 2, ".", ",") . "MB (" . number_format($subAcctTotalbytesRemaining/1024, 2, ".", ",") . "GB)* of " . number_format($subAcctTotalbytes, 2, ".", ",") . "MB</li>\n";
							}

djjjozsi

if you need to troubleshoot a code, its useful if the php posted with BBcodes.

if i see a ocde, and the closing and starting { } courly brackets don't match that means the code is wrong.

if its an error in your code, normally the error reporting tells where is the problem.

If this ettings has turned off, you can switch back:

error_reporting(E_ALL);
ini_set("display_errors", 1);

mlosier

Ok sorry this is my first time posting here. is this better?

for($j=0;$j<sizeof($pgServices);$j++) 
					{
						$subAcctArry = pSQLGetAssocArry("SELECT * FROM cust_svc WHERE pkgnum = '" . $curr_pkgnum . "'");
						if(sizeof($subAcctArry)>0) {
							$subAcctSvcNum = pSanitize($subAcctArry[$j]["svcnum"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM cust_svc WHERE svcnum = '" . $subAcctSvcNum . "';");
								$subAcctPkgNum = pSanitize($subAcctArry[0]["pkgnum"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM cust_pkg WHERE pkgnum = '" . $subAcctPkgNum . "' and susp is null and cancel is null;");
								$subAcctPkgPart = pSanitize($subAcctArry[0]["pkgpart"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM svc_acct WHERE svcnum = '" . $subAcctSvcNum . "' ORDER BY username ASC ;");
								$subAcctUserName = pSanitize($subAcctArry[0]["username"]);
								$subAcctTotalbytesRemaining = $subAcctArry[0]["totalbytes"] / 1048576;
								$subAcctLastLogout = pSanitize($subAcctArry[0]["last_logout"]);
							$subAcctArry = pSQLGetAssocArry("SELECT * FROM part_pkg_option WHERE pkgpart = '" . $subAcctPkgPart . "' AND optionname = 'totalbytes';"); 
								$subAcctTotalbytes = $subAcctArry[0]["optionvalue"] / 1048576;
							$subAcctArry = pSQLGetAssocArry("SELECT optionvalue FROM part_pkg_option WHERE pkgpart = '" . $subAcctPkgPart . "' AND optionname = 'totalbytes';");
							if(($subAcctTotalbytes == 0)) {
								if($subAcctTotalbytesRemaining > 0) {
									//some dis-parity here... Feather the benefit of the doubt and just display 
									//$subAcctTotalbytes MB of 0MB remaining... something's obviously messed up here
									$subAcctInfo .= "<li>User: <a href='" . $_SERVER["PHP_SELF"] . "?act=userinfo&reqUser=" . $subAcctUserName . "'><b>" . $subAcctUserName . "</b></a><br />\nTotal transfer remaining: " . number_format($subAcctTotalbytesRemaining, 2, ".", ",") . "MB (" . number_format($subAcctTotalbytesRemaining/1024, 2, ".", ",")  . "GB)* of <b>Unlimited</b><br />Please call your account representative to have this corrected.</li>\n";
								}else {
									$subAcctInfo .= "<li>User: <a href='" . $_SERVER["PHP_SELF"] . "?act=userinfo&reqUser=" . $subAcctUserName . "'><b>" . $subAcctUserName . "</b></a><br />\nTotal transfer remaining: <b>Unlimited</b></li>\n";
								}
							}else {
								$subAcctInfo .= "<li>User: <a href='" . $_SERVER["PHP_SELF"] . "?act=userinfo&reqUser=" . $subAcctUserName . "'><b>" . $subAcctUserName . "</b></a><br />\nTotal transfer remaining: " . number_format($subAcctTotalbytesRemaining, 2, ".", ",") . "MB (" . number_format($subAcctTotalbytesRemaining/1024, 2, ".", ",") . "GB)* of " . number_format($subAcctTotalbytes, 2, ".", ",") . "MB</li>\n";
							}							
						}
					}

djjjozsi

try to print the results after on all selects:

is this pSQLGetAssocArry() function logging the mysql_error() reports?

mlosier

It is not giving me any errors, i am seeing the results but it's not ordering them by username.

djjjozsi

as i can imagine this program,

                            $subAcctArry = pSQLGetAssocArry("SELECT * FROM svc_acct WHERE svcnum = '" . $subAcctSvcNum . "' ORDER BY username ASC ;");
                                $subAcctUserName = pSanitize($subAcctArry[0]["username"]);

this could only use one row from your select, [0] means the first index from the result's array. This is a sub query based on a $subAcctSvcNum value from the previous select.

How do you think the order according to a user in a case like this?

mlosier

djjjozsi;10920591 wrote:
as i can imagine this program,

this could only use one row from your select, [0] means the first index from the result's array. This is a sub query based on a $subAcctSvcNum value from the previous select.

Yes this is right. but how do you think i could re-arrange the code so i can sort it by username.

Thanks

toxic_brain

r u trying to sort the array $subAcctUserName on username?