ley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 26 July 2006 11:25 PM
To: [EMAIL PROTECTED]
Cc: Mark Dale; mysql@lists.mysql.com
Subject: Re: Returning results as a field name
Pardon me, too early & not enough coffee, that's not quite the
'max-concat trick', but it oughtta
Yes | No |
+---+--+--+
2 rows in set (0.00 sec)
Any clues to get the other questions and their answers into the table
greatly appreciated.
cheers
Mark Dale
***********************
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 26 July 2006 2:54
-+--+--+
| Mark | Yes | No |
| Leigh | Yes | No |
+---+--+--+
2 rows in set (0.00 sec)
Any clues to get the other questions and their answers into the table
greatly appreciated.
cheers
Mark Dale
***********
-----Or
lues to get the other questions and their answers into the table
greatly appreciated.
cheers
Mark Dale
***
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 26 July 2006 2:54 PM
To: Mark Dale
Subjec
Mark Dale wrote:
Hello MySQL List
I have a simple table that outputs results like so:
select name, question_id, answer from table;
+---+--+-+
|NAME |QUESTION_ID |ANSWER |
+---+--+-+
|Mark |100 |Yes
