Search found 4 matches

by DevBear
Tue May 10, 2005 12:06 pm
Forum: PHP - Code
Topic: GROUP BY Query + Alternating Table Row Classes
Replies: 3
Views: 349

OK, thanks; I'll check that out.
by DevBear
Tue May 10, 2005 12:05 pm
Forum: PHP - Code
Topic: GROUP_CONCAT Equivalent
Replies: 0
Views: 149

GROUP_CONCAT Equivalent

The following SELECT statement works on my local site, but not on my remote site because my host hasn't upgraded to MySQL 4.1. $res = mysql_query("SELECT GROUP_CONCAT(DISTINCT Area SEPARATOR ', ') as Area, Class, ClassCommon, OrderCommon, `Order` FROM symbols WHERE Class = '$myname' GROUP BY `O...
by DevBear
Tue May 10, 2005 2:16 am
Forum: PHP - Code
Topic: GROUP BY Query + Alternating Table Row Classes
Replies: 3
Views: 349

P.S. I just learned that GROUP_CONCAT isn't supported by the MySQL version my host is using. So much for that idea!
by DevBear
Tue May 10, 2005 12:09 am
Forum: PHP - Code
Topic: GROUP BY Query + Alternating Table Row Classes
Replies: 3
Views: 349

GROUP BY Query + Alternating Table Row Classes

I apologize in advance for this lengthy post, but I don't think I'm going to solve this problem without tackling two problems at the same time - writing a script that includes a GROUP BY query and a script for generating alternating table classes. When I focus on just one, there's inevitably a confl...