MySQL/PHP Variable Question

[Graphics]

OK, I'm making my own Itemshop. But I'm not the best coder around and need some help with something simple.

I need multiple things to show up from the same MySQL table column. For example, here's a part of my file:

// select information
$shop_id     = $DB_site->query("SELECT shop_id FROM itemshops");
$shop_name   = $DB_site->query("SELECT shop_name FROM itemshops");
$shop_image  = $DB_site->query("SELECT shop_image FROM itemshops");
$shop_rating = $DB_site->query("SELECT shop_rating FROM itemshops");
$shop_profit = $DB_site->query("SELECT shop_profit FROM itemshops");
$shop_total  = $DB_site->query("SELECT shop_total FROM itemshops");

Now, if I have, for example, 3 Itemshops, how would I get the three Itemshop's attributes to show? Use the variables three times? :ermm:

Thanks.