Database SELECT Query performance

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

meaby you still don't see it, but there is only 1 query in my code.

and then i iterate over the result of that query (but don't perform any extra queries in that iteration)
User avatar
kendall
Forum Regular
Posts: 852
Joined: Tue Jul 30, 2002 10:21 am
Location: Trinidad, West Indies
Contact:

Post by kendall »

WEll i found a GROUP_CONCAT fnction that allows me to GROUP the results. This would have been exactly what i needed....however im working wit a lesser version...ARGHHH!!!!!!
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

there's group_concat implemented as UDF (user defined function): http://www.codeproject.com/Purgatory/mygroupconcat.asp
Post Reply