Putting the database to work.

[tet3828]

I must not have posed this question properly last post....22 reads to 1 response ::). Allow me to simplify...

I have a database. Each Item in the database will have  the following values:
CATAGORY
SUB-CATAGORY
STORE ITEM NUMBER
NAME
DESCRIPTION
PRICW
PRICE SMALL PICTURE
PICTURE

what script should I start with if I need all items in a selected catagory to be displayed in a table including an itme Name, Thumbnail, and price?

Thanks again! ;D

[argoSquirrel]

[quote author=tet3828 link=topic=112534.msg456780#msg456780 date=1161695109]
I must not have posed this question properly last post....22 reads to 1 response ::). Allow me to simplify...

I have a database. Each Item in the database will have  the following values:
CATAGORY
SUB-CATAGORY
STORE ITEM NUMBER
NAME
DESCRIPTION
PRICW
PRICE SMALL PICTURE
PICTURE

what script should I start with if I need all items in a selected catagory to be displayed in a table including an itme Name, Thumbnail, and price?

Thanks again! ;D
[/quote]

Ok, you just want items filtered by category?

If so your SQL would be:
[code]
SELECT name, picture, price
FROM Items
WHERE category = @var
[/code]

Is that what you're asking?