Thanks Jazz. I have resolved it now.

Just browsing over and I saw this message..

Warning: Invalid argument supplied for foreach() in /home/fhlinux162/w/wp-fun.co.uk/user/htdocs/wp-content/plugins/fun_with_in_context_comments.php on line 340

Just to let you know.

Thanks Eric, I’ll take a look at that. The reason I want to do it in SQL instead of PHP is that I am doing a join with another query and I want to return a single result in a way that is consistent with the native WordPress query.

http://en.wikibooks.org/wiki/Programming:MySQL/Pivot_table

A pivot is what you were looking for, but my first way would work just as well and is a little more understandable. (IMO)

You are fundamentally changing your data model there. You could have 0..n columns returned, and i dont know how you would handle that in a static sql query without knowing the result first.

why not:
select names, values from table where id = 1

then

foreach(result) {
add it into an array
}

Your data model “Query Results” is really an array.

Hope that helps.