Help with database design and quering rows
<p>What's this database design and it is displaying three rows of id in names in products and three rows of prices, and three row of each field when I am looking for to display the name, variety and price in one row then the next row display another different set of field values different than the first row. How can I achieve that with that with the database design below? </p>

<pre><code>CREATE TABLE products (
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
name VARCHAR(255)
);

CREATE TABLE product_varieties (
product_id INT,
variety VARCHAR(100),
price DOUBLE,
description TEXT,
PRIMARY KEY (product_id, variety)
);

INSERT INTO products (id, name) VALUES (1, 'Cotél de camarone');
INSERT INTO product_varieties (product_id, variety, price) VALUES (1, 'Small Tray',   2.9);
INSERT INTO product_varieties (product_id, variety, price) VALUES (1, 'Medium Tray', 6.9);
INSERT INTO product_varieties (product_id, variety, price) VALUES (1, 'Large Tray', 8.9);
</code></pre>

<p><a href="http://www.nyhungry.com/example2.php?subject=4&amp;id=2&amp;register=1&amp;menu=38" rel="nofollow">Go here to see an example of what I am talking</a>.
Again I want the price 2.9 to display in small tray of the first row, then 6.9 display in the medium tray of the first row, and 8.9 display on large tray of the first row. Right now is display prices for row...</p>

<p>help.</p>
