Thanks Rick Yes, I know it's not going the most (in lack of descriptive words) pretty piece of code. The variable number of columns is the key phrase here.
I've already told them, this is not a SQL task, but having infinite trust in my peers "out there" I know it can be done. I just fail to do the logic myself. Believe me, I tried. On Wed, November 14, 2012 16:49, Rick James wrote: > While it is possible to pivot a table like that, the code is ugly, and > does not work well if you need a variable number of columns. > > SQL can do the JOIN to get a single resultset for the information, but the > layout is best done in a application language, such as PHP. > >> -----Original Message----- >> From: Mogens Melander [mailto:mog...@fumlersoft.dk] >> Sent: Wednesday, November 14, 2012 12:23 AM >> To: mysql@lists.mysql.com >> Subject: Dynamic crosstab got me lost. >> >> Guru's >> >> I've been tasked with creating a report with information about which >> images >> are related to each active article. The images are descriptive icons >> visualizing different properties. >> >> Articles can be active 'on' or not '', and only active is to be included >> in >> the result. >> >> The number of available icons changes constantly, and are too many, to >> use >> anything static. >> >> What I got is: >> >> Table: main >> ----------------- >> code (int) >> active (on/off) >> ----------------- >> >> Table: icon >> ----------------- >> id (int) >> filename (char) >> ----------------- >> >> Table: iconrel >> ----------------- >> code (int) >> icon (int) >> ----------------- >> >> What I need is something like: >> >> code filename1 filename2 filename3 filenameN >> 1111 on off off on >> >> Hopefully somebody out there got more of a clue than I do. >> >> Any ideas, anybody? >> >> -- >> Mogens Melander >> +66 8701 33224 >> >> -- >> This message has been scanned for viruses and >> dangerous content by MailScanner, and is >> believed to be clean. >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > -- Mogens Melander +66 8701 33224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
