[micheal332001]

Originally Posted by Pearl

everything works however it genrates a error in tournaments
then view players when 0 is entered

Invalid SQL:

SELECT round0,round2,round3,playerusername,tid,playerwins ,playerlosses,champion,team FROM leaguetournament_players WHERE tid = '1' AND round0 = '0' ORDER BY round0 ASC;

MySQL Error : Unknown column 'round0' in 'field list'

i know this comes from entering 0 and when i enter 1 its ok, but isnt there a way to set it to prevent from entering 0?

When you put the round number in you need to put 1 for round 1 not 0 thats why.