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
[EMAIL PROTECTED]
-----Original Message-----
From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 28, 2006 3:43 AM
To: [email protected]
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.
--
Chris W
KE5GIX
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
