Page 2 of 2

Posted: Mon Nov 08, 2004 11:18 am
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)

Posted: Mon Nov 08, 2004 11:35 am
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!!!!!!

Posted: Mon Nov 08, 2004 1:27 pm
by Weirdan
there's group_concat implemented as UDF (user defined function): http://www.codeproject.com/Purgatory/mygroupconcat.asp