ASP Help!

[JohnMitch]

I am in some need of assistance with starting my website. I know very little ASP but after reading many posts in this forum I am learning a lot. This is what I need help with though.

Each user I have gets to have thier own storefront. I know how to add the items, and stuff but I don't know how to manage these. Do I throw them all into one table and just use ASP to filter by username? Or is there someway that ASP can group these names together in that table?

Example:

Bob | Coffee | $5
Bob | Books | $7
Jim | Coffee | $4
Bob | Toys | $2

I know by trying to retrieve Bob's information I would have to run a check to make sure that every item that is displayed is Bob's Item. So is there a way in ASP to insert Bob Toys above Jims so that I can use that after it finds Bob's last entry it will end? Or is there another way that is easier? Any help is much appreciated.

[Webforumz Staff]

ASP can do pretty much whatever you want with your table, but you'll probably end up doing it through SQL queries.

A tutorial on SQL, SELECT, WHERE, ORDER BY, GROUP BY etc

[JohnMitch]

interesting... I never knew you could use anything else to do this. Pretty neat.

[Webforumz Staff]

Well, I would call it an "else" so much as you use SQL within ASP, so it's a combination of the two. Though you'd also use SQL with PHP, or JSP, or whatever when working with a database in general.

[JohnMitch]

Yeah, well what I meant is that I never knew SQL could do anything other than open a database and locate a table... It can do all kinds of other things. I'm working on this tutorial and if I need some help I'll be posting back. Thanks again.