Cassie_au

Thanks a lot guys!! With your help i got those pages done! I was thinking, if i have 3 tables (3 diff categories of products), how would i go about making only 1 detail page which will collect the id from whichever link is clicked? ($sql = "SELECT * FROM `table`..) sort of bars me down to one table on the detail page :s thanks in advanced for your help!

Thanks Jonsjava you did all the scripting so fast! and thanks a lot Matt for explaining it all too!! ill try this out tonight, thanks guys!

hey guys! i am looking to display items from a mysql database onto a page where each item has a link to a more detailed page (on the item). I understand this is called 'Master/Detail' in Dreamweaver however doing this using script, i can't find any tutorials :s (is it much harder than just displaying data onto a page from the db?) also, if i only want to display a certain amount of information from the description field, how would i go about culling the rest of the displayed data? (usually replaced on sites with '...Read More') Thanks a lot guys!

Thanks a lot Mezise! you've been a great help!

hi! should product_id be a foreign key with PRODUCTS.id? and what would happen if there is more than one item in the order? thanks mezise!

Hey thanks again mezise! sorry my questions must sound so dumb to yous. i have to make an 'orders' table also. besides: id, date, customer_id, and amount fields, shouldn't there also be a field for the product(s) theyre ordering? and what if there's more than one product? thanks in advanced!

hey mezise! thanks for the help! that actually answered a lot of my questions! however ive come across another prob: im making a table for members when they sign up. i have a field for Date of Birth, what field type should it be? DATE? thanks again guys!

hey guys!! found this forum while looking for help :s im currently doing an assignment for school with php and mysql. i need to setup some tables for items in a shop, however i need to include foreign keys. could anybody give me any ideas as to which table fields would link to what? (as an example) thanks in advanced guys!