justAnoob Posted March 4, 2009 Share Posted March 4, 2009 Ok, here it is. I have a database in mysql with 10 different tables. A student will enter some info in a description box and then choose a grade level from a listmenu box. Getting the info from the description box into a table in mysql is easy. How would I go about having it so when they select a grade level from the listmenu and hit the submit button, the student and the info would go into the appropriate table. Quote Link to comment Share on other sites More sharing options...
dt192 Posted March 5, 2009 Share Posted March 5, 2009 this should get you going http://www.tizag.com/mysqlTutorial/mysqlinsert.php Quote Link to comment Share on other sites More sharing options...
justAnoob Posted March 5, 2009 Author Share Posted March 5, 2009 What would the best way to link some tables for something like this....... I have a lot of users, with their passwords and email. Also have their address information. And then also have some picture information, such as image path, image name and image description.(pictures of the family). How would I set up the table for the picture information to hold muliple image info??? Each time a user uploads a new pic, could PHP just add a new field in the mysql table... such as this imgpath1 imgname1 imginfo1,,,,imgpath2 imgname2 imginfo2,,,, and so on. Any of you understand what I am trying to do? I would like to keep all of my tables linked together with an id so I could pull certain info on an admin page. Any ideas? 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.