Jump to content

Archived

This topic is now archived and is closed to further replies.

johntp

Need help with making tables

Recommended Posts

Hey guys i just got the extention for dreamweaver the Dynamic Dependant Menus and im trying to setup a table to store the stuff but i dont know how to set the table up........ do i use varchar ect.........

You have to set it up like this
Table: Types

id_type type
1 Book
2 CD

Table: Genre

id_genre genre
1 Sci Fi
2 Terror
3 Modern Novel
4 essay
5 Brit Pop
6 New Age
7 Madchester

Table: Authors

id_author auther
1 Issac Ossimov
2 another
3 another
4 ECT.....
5 ect.....
6 ect
7 ect

Table: tbl_items

id_item item id_author id_genre id_type
1 blah1 1 4 2
2 blah2 2 3 2
3 blah3 3 2 2
4 blah4 1 1 2
5 blah5 4 1 2
6 blah6 5 7 1
7 blah7 5 7 1
8 blah8 6 6 1
9 blah9 7 5 1

Im soooooo Lost. LOL post if you can help me.

Edit:Didnt post like i thought it would so just think of it as suppose to be tables with the #'s under the items

Share this post


Link to post
Share on other sites
Sure, you can use VARCHAR(255) for each text field, though you may want to split off first/last for the authors table. Otherwise, use UNSIGNED INTs for storing IDs.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.