parino_esquilado Posted December 21, 2009 Share Posted December 21, 2009 Ok, so my name is James, and I am creating a MySQL database for my ICT project. I started learning php last week, and have no clue where to go with MySQL, I do have phpMyAdmin however. I am obviously new to using MySQL and php, and would appreciate if I could have some help along the way. I am not here to ask people to do anything for me, cause I know how rude that is, and it is for school, so I do need to do it for myself. For my school project I need to create a website for a fitness center. The website will be used by a receptionist and they will register users, staff and add fitness classes via this website. I will be using WAMP in order to create this. There need to be three tables: 'Members', 'Trainers' and 'Classes'. For the 'Members' table I need the following fields to be present: 'memberid', 'forename', 'middlename', 'dob', 'gender', 'address1', 'address2', 'citytown', 'postcode', 'telno', 'email' and finally 'class'. The 'class' field will need to be linked to the 'Classes' table obviously. The 'Trainers' table will require the same fields as the 'Members' table, with the exception of 'memberid' becoming 'trainerid'. And now the 'Classes' table will require the following: 'classid', 'classtype', 'classday', 'classstarttime', 'classendtime', 'classcost'. The relationship between the tables will need to be as follows: Trainers ---> Classes <--- Members (both 'Trainers' and 'Members' need to link. Please, I don't have a clue where to begin! Help?! I am trying to get this done by the end of the week. Could someone help me please? Thanks, James Quote Link to comment Share on other sites More sharing options...
fenway Posted December 21, 2009 Share Posted December 21, 2009 Well, have you set up the primary tables? Quote Link to comment Share on other sites More sharing options...
bacarudaguy Posted December 22, 2009 Share Posted December 22, 2009 http://php.net http://dev.mysql.com Two good places to start, even IF you have a book to help you with either... Quote Link to comment Share on other sites More sharing options...
parino_esquilado Posted December 22, 2009 Author Share Posted December 22, 2009 Well, have you set up the primary tables? I haven't, no. I am yet to understand how it is exactly that I will be able to create the tables with all the many different options like 'Type' that you have to chose. I am perplexed. :|. Quote Link to comment Share on other sites More sharing options...
fenway Posted December 22, 2009 Share Posted December 22, 2009 Well, there are some excellent resources in the "sticky" if you're looking for a place to start. Quote Link to comment 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.