RE: returning empty columns - Price, Randall - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRE: returning empty columns

From	Sent On	Attachments
2wsxdr5	28 Feb 2006 00:42
Rhino	28 Feb 2006 05:27
Price, Randall	28 Feb 2006 06:54

Subject:	RE: returning empty columns
From:	Price, Randall (rand...@vt.edu)
Date:	02/28/2006 06:54:17 AM
List:	com.mysql.lists.mysql

Chris,

See if this works for you:

SELECT ' ' as 'Call' , concat(FName, ' ', LName) as Name , ' ' as 'Mar-6' , ' ' as 'Mar-13' , ' ' as 'Mar-20' , ' ' as 'Mar-27' FROM table ORDER BY LName, FName

Notice that there is a single blank space being returned for the Call, Mar-6, Mar-13, Mar-20, Mar-27 columns. I tried returning null as well as an empty string (i.e., '') but those did NOT give me column headings.

Hope this helps.

Randall Price VT.SETI.IAD.MIG:Microsoft Implementation Group http://vtmig.vt.edu Rand...@vt.edu

-----Original Message----- From: 2wsxdr5 [mailto:2wsx...@cox.net] Sent: Tuesday, February 28, 2006 3:43 AM To: mys...@lists.mysql.com Subject: returning empty columns

This is probably going to sound like an odd request, but is there a way to return empty columns in Mysql. For example a roll call sheet I want to do a select of names from my table and then add a column for each of

the next 12 weeks. I tried this.....

SELECT `Call`, concat(FName, ' ', LName) as Name, 'Mar-6' ,'Mar-13', 'Mar-20', 'Mar-27' FROM table Order BY LName, FName

The problem is it put that date on every row and I just want the names to show up in the column header I know I could just write some php code

to print out a table with the columns but I have a handy php function the prints the out put of a query in a table already so if I can find the right query I don't have to change that code any.

Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com