passing varible in a sql statement

[Anon]

hey,
ive got this query and trying to specify the name of a field in my query by using a varible in my code.
here is my query. its not working!
"select products_id, products_name, products_description, products_quantity, products_rating, products_starring, products_format, products_condition, products_high_cost, products_newdvd, products_newvhs, products_newwvhs, products_usedvhs, products_useddvd, products_director, products_model, products_quantity, products_image, products_url, pricenew_vhs, price_new_dvd, price_used_vhs,'price_' . $format, products_price, products_date_added, products_date_available, products_available_date, manufacturers_id from products where products_id = '" . $HTTP_GET_VARS['products_id'] . "'"

ummm, $format is the variable im talking about. how do can i put that into my query??

Rooin.

[veron]

"select products_id, products_name, products_description, products_quantity, products_rating, products_starring, products_format, products_condition, products_high_cost, products_newdvd, products_newvhs, products_newwvhs, products_usedvhs, products_useddvd, products_director, products_model, products_quantity, products_image, products_url, pricenew_vhs, price_new_dvd, price_used_vhs,price_" . $format . ", products_price, products_date_added, products_date_available, products_available_date, manufacturers_id from products where products_id = '" . $HTTP_GET_VARS['products_id'] . "'"