hi..
im creating a football website!!
when they register they pick 11 players
what i want is that there is a rule where no more than 2 players from a team can be picked!
any ideas??
i've tried and failed.... here's an idea of what i tink it mite be like!
$query1=mysql_query("select p_team from players where p_id = '$player1'");
$row = mysql_fetch_array($query1);
$arsenal = arsenal
$arsenal = $ars
$ars ="0";
$ast ="0";
$bir ="0";
$bla ="0";
$bol ="0";
$cha ="0";
$che ="0";
$eve ="0";
$ful ="0";
$lee ="0";
$liv ="0";
$mc ="0";
$mu ="0";
$mid ="0";
$new ="0";
$sot ="0";
$sun ="0";
$tot ="0";
$wba ="0";
$wh ="0";
$query1=mysql_query("select p_team from players where p_name = '$player1'");
$row = mysql_fetch_array($query1);
while($row != 0)
{
$row++
// get team for player1
// and increment it.
// if team >2
// error
// else continue
//
any suggestions???
really appreciate it!
ive a deadline of 2moro so very worried!!!!
