The probem with that is that I'd be counting the total number of matches, I need to be able to count the number of entries in a single column of a table. So in the colums players (just as an example) I would be able to insert people into that colum, but I'd like to count the number of people that are in that particular column. I don't understand what good it would to to count all of the entries in my table, that would just give me the first 8 people to sing up ever, I will not be clearing the table each round, I want to store the data of each row, and then start a new row for each and every match. And within each row have a space for people to sign up. Should I maybe create 8 new columns slot1-8 or something and insert into each column? or is there a way to put all 8 players into 1 column called players. I could potentially maniupulate my columns with a for clause... Here's my table so far, with an example of the data I'd like to have entered.
I've already made a simple script to let me add/edit/delete matches based of the match_id variable. I am going to make a separate script that will allow people to signup to play in a particular match (ie those that are still not filled.) and if there are 8 signed up for the match they won't be allowed to signup
CREATE TABLE `ladder` (
`match_id` int(4) NOT NULL auto_increment,
`opponent` varchar(255) default NULL,
`tag` varchar(255) default NULL,
`ladder` varchar(255) default NULL,
`map` varchar(255) default NULL,
`time` varchar(255) default NULL,
`location` varchar(255) default NULL,
`outcome` varchar(255) default NULL,
?? what should I do for the players in the match?
PRIMARY KEY (`match_id`)