nec9716 Posted March 25, 2008 Share Posted March 25, 2008 this should be a very simple question: if I want to build tables in mysql how can I set them? my project is I have player who pick number and I have result every week so do I have to create table for players ( id,name ) table for player pick ( id , number1, number2 ) table for result (id,week,result ) or someone have a better solution ... thank you Link to comment https://forums.phpfreaks.com/topic/97788-confusing/ Share on other sites More sharing options...
trq Posted March 25, 2008 Share Posted March 25, 2008 Seems logical enough. All tables should have an auto incrementing id field. While player_pick and result would also have a player_id field which you would use as your foriegn key. Link to comment https://forums.phpfreaks.com/topic/97788-confusing/#findComment-500331 Share on other sites More sharing options...
nec9716 Posted March 25, 2008 Author Share Posted March 25, 2008 ok ...i just want to be sure ....thank you I know how to write in one table but I'm not sure how to do :? if I have to enter data from player#1 in 1 table with is pick in the other table? Link to comment https://forums.phpfreaks.com/topic/97788-confusing/#findComment-500334 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.