Below is what I was asking for. Like Jim said, it is something you could do in a couple clicks if you knew how as opposed to us hand writing it out. We spend a lot of our time on this board helping people, so the easier you make it for us to help you the quicker and more likely you will get a response. At the time you posted, I didnt have the time, nor the desire to type it all out. A brutha has to make a living too. We dont get paid on this board.
If you are interested in learning as opposed to just getting the fix you need I will post some additional querys you may find useful to what you are doing. Things like Get all the results where Washington won, or everyone they lost against. Their average for the season or a quarter (Gotta see if they are improving for those Vegas bets right?) Stats between XXX year and XXX year, Ranking by team, etc…
I can also introduce you to subquerys. If there is specific info you would you would like to see let me know.
If your going to be working with Databases a lot I would I would HIGHLY recommend you get Navicat for Mysql http://www.navicat.com/products/navicat-for-mysql
It is far superior over phphmyadmin and can run locally on your computer as opposed to needing a server to run it. If you were a Carpenter, Navicat would be the hammer in your tool box.
Since you are inexperienced at this time you probably don’t know about or understand the “Relationship” part of Relational Databases. If you would like to provide your DB schema, we can go over it and you can learn some more really neat things you can do. Again, I dont need your actual data, just the sql to recreate your database.
[code]CREATE TABLE score_results
(
id int auto_increment primary key,
schoolID int,
team1_score int,
opponentID int,
team2_score int
);
INSERT INTO score_results
(schoolID, team1_score, opponentID, team2_score)
VALUES
(1001, 6, 2005, 4),
(2001, 8, 2010, 3),
(2005, 10, 2010, 5);
CREATE TABLE team_name
(
id int auto_increment primary key,
schoolName varchar(255)
);
INSERT INTO team_name
(id, schoolName)
VALUES
(1001, “Washington”),
(2001, “Taft”),
(2005, “Howard”),
(2010, “Lincoln”);[/code]
