It sounds like you are wanting to "transpose" rows and columns. But you used the terms convert and fields, so google may not be helping you.
I found this: http://forums.mysql.com/read.php?86,23026,25752#msg-25752 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
