Search found 4 matches
- Tue May 10, 2005 12:06 pm
- Forum: PHP - Code
- Topic: GROUP BY Query + Alternating Table Row Classes
- Replies: 3
- Views: 349
- 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...
- Tue May 10, 2005 2:16 am
- Forum: PHP - Code
- Topic: GROUP BY Query + Alternating Table Row Classes
- Replies: 3
- Views: 349
- 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...