james438
02-20-2008, 05:46 PM
here is an example of the spreadsheets I want to store in my MySQL database: http://spreadsheets.google.com/pub?key=pdFnXIq6rPBa5tvo1aLI_Bg&gid=8
As best I can figure I should create a table called 'attendance' with auto-incrementing ID. The first column would be for the dates of the spreadsheets.
At this point I get lost because there are many names and the next few columns will be comments or stats about each person. My real question is how would you do this with just one table? I want to have a row for each spreadsheet, but I can be flexible if there is a better way of handling the data.
Thanks,
James438
As best I can figure I should create a table called 'attendance' with auto-incrementing ID. The first column would be for the dates of the spreadsheets.
At this point I get lost because there are many names and the next few columns will be comments or stats about each person. My real question is how would you do this with just one table? I want to have a row for each spreadsheet, but I can be flexible if there is a better way of handling the data.
Thanks,
James438