Hi,
I am working on a Access database, where i have got Product, Manufacturer, & Model in one table, I am trying to make quary on products then manufactuer then model.
In Dreamweaver MX - I set up my Products page, now I want to pass the URL parameter if products (e.g Mobile phone or Leather Case - image press) then manufacturer.asp should show the result those data from table, my confusion is how can I minimize the records (like one product has got 10 manufacturer). What I want to show is only one image of the manufacturers. How can I filter this.
Please please, any friend help me or advice me where can I find such a tutorial like these.
Thanks

Babu

Hi,

Can you explain it properly please as I'm not sure what you are hoping to achieve.

Thanks!

Yup - janusz.co.uk

Hi,
Thanks for you valuable time and assitance.
I want make it simple for my visitors, thats why I decied like:
First page all Products
Second page all Manufacturer
Third page all Model

- (e.g. if any one choose Mobile phone, then it will go to manufacturer page, where may be 10 manufacturer name could show) then users can choose (e.g. Nokia or Sony) it will go to next page and show all the models of Nokia, like that.
Now what I am fear with is, how should my database table look like, in a simple table or breaking a part with product, manufacturer, model? Another problem is - passing URL parameter - from page product if i pass with prod_id to the next page(manufacturer) then how can I filter being showing multiple manufacturers name to show just once.
And then how can I go to model page passing URL parameter? Is it still with prod_id?
Hope I could make it clear, looking for furthur advice from you
Many thanks

Babu

I still haven't much of an idea what you need to do as your english isn't the best... <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Yup - janusz.co.uk

I think I understand what you want - there will be many ways to do this, all depend on your knowledge of building DBs and ASP... would you want it to be optimised? is it for a large project?

Yup - janusz.co.uk

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I think I understand what you want - there will be many ways to do this, all depend on your knowledge of building DBs and ASP... would you want it to be optimised? is it for a large project?

Yup - janusz.co.uk

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Hi,
Thanks for your reply, I appology for my bad english. I am still learning.

Well, the project is very small, and its for myself - me n my friend is going to start a small accessories shop, so I thought it will be a great experience for me to start a small project on building online store. I am nobis, and still a lot to learn. Trying my best to catch.

And also I just want make it simple, not complex...because I am not capable to handle big project

I hope you will understand me. Please, feel free to advice me furthur.
Thanks a lot.

Babu

Hey dude,

You can just use a query like:
SELECT DISTINCT manufacture FROM productInfo

It will show you all unique manufactures.

Good luck with your project.



=)

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hey dude,

You can just use a query like:
SELECT DISTINCT manufacture FROM productInfo

It will show you all unique manufactures.

Good luck with your project.

=)

Thanks

Adjactly what I was looking for. One more questtion

From Product page PASS URL PARAMETER = prod_id (go to manufacture.asp)
Then from Manufacture PASS URL Parameter = ??? (go to model.asp)

Shall I continue pass url parameter like prod_id???
Many thanks

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Babu

Adjactly???

1st page - list.asp - just use DISTINCT to get them all listed
2nd page - model.asp?id=1 - select all manufacturers where id=1
3rd page - proper.asp?id=1 - select all.....

Yup - janusz.co.uk