|
|
Posted by Oliver Grδtz on 12/01/07 12:58
Ciaran schrieb:
> Anyone know how to do this? I have a standard 3D array:
>
> $item[0]['title']
> $item[0]['content']
> $item[0]['date']
> $item[1]['title']
> $item[1]['content']
> $item[1]['date']
> etc...
It's _still_ about changing the SELECT. You are trying at the wrong end.
SELECT stuff,foo,bar,date,...,...
FROM t1,t2,t3,...
WHERE .................
ORDER BY date DESC
LIMIT 1
Now you only get the results for the highest date value.
OLLi
--
"You know what? If you were my mom I'd smoke pot too!"
[Rex to Bree, DH 109]
Navigation:
[Reply to this message]
|