[CarltonBirch]

Python is good for beginners , you may try ruby too . Learn ruby from codeacademy or somewhere else. Use shoes toolkit to create GUI apps in the beginning, next move to other tool-kits

[CarltonBirch]

You have a number of questions that you need to answer, but there is one disconnect that jumps out at me: you want to reflect functionality in your DB to a screen display, but you have not considered how to connect the pieces. What the solution needs is:

• Your database – you already have that
• A server function that can query the DB and massage the data – typically written in PHP or Java or similar (model)
• A server function that can take the date from the model and manage the UI interactions, typically written in PHP or Java or similar (view)
• A server function that manages the interactions between the pieces, once again in PHP/Java/etc (controller)
• Your web page(s) written in DHTML (HTML, CSS, JavaScript) to provide the interface to the system

In other words, you need to create a server program that will access the database and present the data to the web page

Now for your database – I think a tournament is a special case of a league and not a different entity, so I would eliminate that, and add a BOOLEAN to the league table “isTournament” to flag that the competition is a tournament rather than a plain ol’ league.

When you create a new league, you generate all the games to be played in the games table. As they are played, you update the winnerId so you can select the completed games records and calculate the rankings.

For a tournament, it’s slightly different. You generate the games for the first round, and generate the next round game records based on the selection of winners. If you have an uneven number of players, one player will be given a bye into the next round, so you simply mark him as the winner as you create the game. Do you have rules for who the winners of one round play in the next round? You can apply these to the system automatically as the results arrive in.

[CarltonBirch]

When you say you run into issues checking the date, do you mean you can’t get the code inside the first if statement to run?

If so, are you sure the content of the $_GET['week'] is in a suitable format? Try doing an 'echo $_GET['week'];', and also an 'echo $game->attribute()->Week;' before the if statement to see what you’re comparing.

[CarltonBirch]

i got a few things i don’t understand,

1. until now it deleted just fine, what Suddenly happens ? i didn’t Touched the code for a month and it happens about a week ago…

2. my hosting company sent me this error log: there are 2 things i dint understand in it :

this is just a part of it:

DeleteId%5B%5D=790&ChangeUp=%D7%9E%D7%A2%D7%95%D7%93%D7%9B%D7%9F&DeleteId%5B%5D=665&DeleteId%5B%5D=366&DeleteId%5B%5D=365&DeleteId%5B%5D=364&DeleteId%5B%5D=362&DeleteId%5B%5D=363&DeleteId%5B%5D=396&DeleteId%5B%5D=397&DeleteId%5B%5D=398&DeleteId%5B%5D=399&DeleteId%5B%5D=400&DeleteId%5B%5D=404&DeleteId%5B%5D=403&DeleteId%5B%5D=619&DeleteId%5B%5D=620&DeleteId%5B%5D=621&DeleteId%5B%5D=622&DeleteId%5B%5D=623&DeleteId%5B%5D=624&DeleteId%5B%5D=718&DeleteId%5B%5D=554&DeleteId%5B%5D=613&DeleteId%5B%5D=614&DeleteId%5B%5D=651&DeleteId%5B%5D=1081&DeleteId%5B%5D=1082&DeleteId%5B%5D=1083&DeleteId%

1. when i try to delete 1 row it try to delete all my date ?
2. or is it Because i have over a 1000 id’s so the search for the right one make it stuck ?