Best way to sort arrays
- From: floortje <none@xxxxxxxxx>
- Date: Wed, 31 Oct 2007 20:38:04 +0100
Hi,
On my page I oftend find myself presenting my data like this
- all entries
1 - first (last modified)
2 - second
3 - last
- last entries
3 - last
- last modified
1 - first (last modified)
I have found a couple of ways to solve this
The first is 3 different queries
$allentries=$db::select('SELECT * FROM entries')
$lastentries=$db::select('SELECT * FROM entries ORDER BY id DESC LIMIT 5')
$lastmodefiedentries=$db::select('SELECT * FROM entries ORDER BY modefied DESC limit 5')
$allentries=$db::select('SELECT * FROM entries')
foreach($allentries as $val)
{
//
$lastentries[$val['id']]=$val;
$lastmodefiedentries[$val['modefied']]
}
// sort by id
krsort($lastentries)
// sort by modefied
krsort($lastmodefiedentries)
// etc
But I cant help wondering there should be a more efficient way to solve this.
In the first solution I use 2 extra queries and in the last soution I use more system resources and it isn't really reusable.
Anyone know a better way ?
Floortje
.
- Prev by Date: Re: Session or browser problem??
- Next by Date: Re: how to create 'remember login' functionality during login
- Previous by thread: Looking for help on what is probably a simple task
- Next by thread: Why is server starting on 0.0.0.0:3000?
- Index(es):
Relevant Pages
|
