SQL: row-to-column-conversion in 1 query

[leo.putz]

Hi there,

I really get nuts
Macromedia Generator needs COLUMNS to create a chart. But data to be
visualized is stored in one ROW (whole record).

Therefore I need a SQL- query which generates one column out of one row
like:

 my wish:my source:

++
| capt.  |
++...
|  10|+---+---+---+
++- SQL- query  -   | 10| 20| 30|...
|  20|+---+---+---+
++...
|  30|
++
  ...


Every help is appreciated - otherwhise I really will fell the pain..

Thanks in advance

Leo




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

row to column conversion

[leo.putz]

Hi there!
Macromedia Generator needs a cloumn as query result to create a chart
from given data (e.g. temperature lows).
My data is stored in records (rows).
Does anybody know a SQL syntax to return one column as query result
containing the information from one row.

Any help is greatly appreciated!
Thanks in advance.

Leo


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php