Jump to content


Photo

Putting the database to work.


  • Please log in to reply
1 reply to this topic

#1 tet3828

tet3828
  • Members
  • PipPipPip
  • Advanced Member
  • 107 posts
  • Locationfort myers, FL

Posted 24 October 2006 - 01:05 PM

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
[ Enter Your Signature Here ]
Always take caution when using other peoples work.

#2 argoSquirrel

argoSquirrel
  • Members
  • PipPipPip
  • Advanced Member
  • 36 posts

Posted 26 October 2006 - 12:34 AM

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


Ok, you just want items filtered by category?

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

Is that what you're asking?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users