johntp Posted May 1, 2006 Share Posted May 1, 2006 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: Typesid_type type1 Book2 CDTable: Genreid_genre genre1 Sci Fi2 Terror3 Modern Novel4 essay5 Brit Pop6 New Age7 MadchesterTable: Authorsid_author auther1 Issac Ossimov2 another3 another4 ECT.....5 ect.....6 ect7 ectTable: tbl_itemsid_item item id_author id_genre id_type1 blah1 1 4 22 blah2 2 3 23 blah3 3 2 24 blah4 1 1 25 blah5 4 1 26 blah6 5 7 17 blah7 5 7 18 blah8 6 6 19 blah9 7 5 1Im 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 Quote Link to comment https://forums.phpfreaks.com/topic/8826-need-help-with-making-tables/ Share on other sites More sharing options...
fenway Posted May 2, 2006 Share Posted May 2, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/8826-need-help-with-making-tables/#findComment-32702 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.