I am writing my own forum add-on for LINKS SQL v.1.3 since the one that widgetz had before was a bit cumbersome to understand...no offense, Jerry.
Anyway...I've designed the appropriate tables and also started writing the forum/topic view scripts. I am having a problem with the FORUM view page:
http://www.anthrotech.com/cgibin/forum/
You'll notice that the only three forums and one category shows up, while there should be 3 categories and 12 forums.
NOTE: Announcements is associated with the Anthro TECH, L.L.C forum category, Linguistic Anthropology is associated with the Anthropological Sub-Fields forum category, and Professional Development is associated with the General forum category.
Here are the relevent codes in the Forum View script:
If I take out the GROUP BY codes, then all the forums are listed in alphabetical order but are not grouped by their category.
Now, I've spent most of the afternoon reading up on GROUP BY functions at http://www.mysql.com and the above codes should work, but I believe that the loop codes may be causing the problem. Yet I also tried running the above SQL statement via the SQL Monitor in MySQLMan and the same results appear as they do in the above linked web page.
I also searched this forum for any ideas, but GROUP BY is not discussed that often...
Just need another pair of eyes to spot any problems.
Any ideas or suggestions are greatly appreciated.
Thanks in advance.
Regards,
Eliot Lee
Anyway...I've designed the appropriate tables and also started writing the forum/topic view scripts. I am having a problem with the FORUM view page:
http://www.anthrotech.com/cgibin/forum/
You'll notice that the only three forums and one category shows up, while there should be 3 categories and 12 forums.
NOTE: Announcements is associated with the Anthro TECH, L.L.C forum category, Linguistic Anthropology is associated with the Anthropological Sub-Fields forum category, and Professional Development is associated with the General forum category.
Here are the relevent codes in the Forum View script:
If I take out the GROUP BY codes, then all the forums are listed in alphabetical order but are not grouped by their category.
Now, I've spent most of the afternoon reading up on GROUP BY functions at http://www.mysql.com and the above codes should work, but I believe that the loop codes may be causing the problem. Yet I also tried running the above SQL statement via the SQL Monitor in MySQLMan and the same results appear as they do in the above linked web page.
I also searched this forum for any ideas, but GROUP BY is not discussed that often...
Just need another pair of eyes to spot any problems.
Any ideas or suggestions are greatly appreciated.
Thanks in advance.
Regards,
Eliot Lee