using foreach to break a list into groups

[johnmerlino]

Hey all,

 

I'm wondering the best way to use foreach to break a list of records into groups. For example, the problem with this:

 

	foreach($vanity_url as $v){
	if($v->approved){
		echo "Approved vanity urls:";
		echo $v->url;
	}
	else {
		echo "Unapproved vanity urls:";
		echo $v->url;	
	}
}

is it will return this:

 

Approved vanity urls:
michellefrancis
Unapproved vanity urls:
johnmerlino
Unapproved vanity urls:
ericmayers

 

when I want it to return this:

Approved vanity urls:
michellefrancis
Unapproved vanity urls:
johnmerlino
ericmayers

 

thanks for response

[dcro2]

Put 'em into two arrays?

 

//might have scope problems otherwise?
$approvedurls = array();
$unapprovedurls = array();

foreach($vanity_url as $v){
	if($v->approved){
		$approvedurls[] = $v->url;
	}
	else {
		$unapprovedurls[] = $v->url;
	}
}

echo "Approved vanity urls:";
foreach($approvedurls as $url) echo $url;
echo "Unapproved vanity urls:";
foreach($unapprovedurls as $url) echo $url;

 

I'm still confused how you got that output without any newlines however.

[PFMaBiSmAd]

a list of records

 

^^^ If that means database records, why not just get your query to return the results in the order that you want them and then simply iterate over the records (once) and display them the way you want?

[johnmerlino]

@PFMaBiSmAd

 

So you are saying create two variables:

$approved = "select * from vanity_urls where approved=1";

$unapproved = "select * from vanity_urls where approved=0";

and then iterate through the variables?
echo "approved:";
foreach($approved as $a) echo $a->url;

echo "unapproved:";
foreach($unapproved as $u) echo $u->url;

 

That is faster than storing them in arrays in php and iterating through the php arrays?

 

Thanks for response.

 

 

[johnmerlino]

or do you mean:

 

$results = "select * from vanity_urls order by approve asc";

 

foreach($result as $r) echo $r->url;

 

[PFMaBiSmAd]

Assuming you want the approved ones first -

 

select * from vanity_urls order by approved desc

 

Add any other ORDER BY condition after the approved desc, for example -

 

select * from vanity_urls order by approved desc, url asc

[johnmerlino]

Assuming you want the approved ones first -

 

select * from vanity_urls order by approved desc

 

Add any other ORDER BY condition after the approved desc, for example -

 

select * from vanity_urls order by approved desc, url asc

 

That works pretty well. Thanks for response.