SELECT and using the field names

Anon

I have a table with inventory stuff in it and would like to know how to display the results. I'll use a simple example to ask my question about displaying resluts from a query.

I have table called beverages. The primary field is the user name. All the other fields are int(11), not null, and default 0. The purpose of the fields is to display how many of each item the person owns. The field names are user_name, Pepsi, Coke, and Sprite. Under the record "Don" it has vales of 2, 1, and 3 respectively. What I can do using a query and fetch_array, then a foreach, I can print the values out one each in a new table row. So the results are:
2
1
3

What I want to do is display the filed name also, so it looks like:
Pepsi 2
Coke 1
Sprite 3

Also, if there is a way to have it not return a result if the entry is 0, so that if there 0 Sprite, it would only display Pepsi and Coke. The reason I don't create a table with the filed names hardcoded in already is (1)the 0 fields won't be displayed and (2) there are several hundred fields in the inventory database I am using and I would like to be able to add more at any given time without having to hardcode hem into a table also at the same time.

I hope this makes sense, if you can help, I would really appreciate it, feel free to e-mail if I don't make something clear here and you want to furthur describe my prob.

Thanks

Anon

select 'Pepsi', pepsi from beverages
where pepsi <> 0 union all
select 'Coke', coke from beverages
where coke <> 0 union all
select 'Sprite', pepsi from beverages
where pepsi <> 0

Some redesign perhaps

username, beverage, quantity

Anon

A mistake in my previous post in the last predicate

select 'Pepsi', pepsi from beverages
where pepsi <> 0 union all
select 'Coke', coke from beverages
where coke <> 0 union all
select 'Sprite', pepsi from beverages
where Sprite <> 0

Anon

That will work, thanks, but then I have do a select statement for every field, I have roughly 1400 of them, isn't there a way to do somekind of automated loop?

Anon

Okay I got it to work this weekend, I just did a do..while loop with a counter set at the beginning and incremented by 1 at the end, with a select statement for that field number set as tha counter in the loop.