URGENT --- a counter to limit team

[susi]

Hi..
im creating a football site and a person when they register pick 11 players... now i want a couple of rules to make it hard

one being that no more that 2 players from any one team..

any ideas how to go about this?? don't like the idea of arrays as i am weak at them!
was thinking something along this lines but im stuck!

<?PHP
$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)
{
$___++

// 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!!!!

[hilln2]

hey people

im with this girl....actually could do with a few pointers on this one!

its really buggin me! 😕

the code is same as above but not sure how i get it to read what team $row is?

e.g. if player1 is D. Seaman, the query will return 'ars'
so therefore, $row = 'ars'; yeah!??
but how do i get the system to read what team the query returned and increment that team and not another!??

N.B: its supposed to be

while($row != 0) 
{ 
$row++ 

all help on this matter is greatly appreciated!

[barand]

$query = "select p_team, teamid, count(*) as pcount from players group by p_team, teamid having pcount > 2"

assuming your recs have a teamid of some sort

hth

[hilln2]

thanx for swift reply

unfortunatley i dont have a teamid, and with such a large database, i couldnt afford to drop the table and re-create it.

also, what does count(*) as pcount mean or even do? Ive never met it before?

If I cant have a teamid, is there another way around this?

thanking you

[barand]

by teamid I mean an identifier for who picked the team. I'd expect there is something like that.

count(*) gives count of records, rather than a count of values in a particular field.

[hilln2]

ok i get you!

so do i just put that query in and leave out the rest of my code...or what should i do!?

[hilln2]

ok, ive put the query into my database and it returned

every username(teamid), every club and how many players in that team.

i.e.

cheapo utd ars 22
bandit city ars 22
athletic cabbages ars 22
cheapo utd bir 24
bandit city bir 24
athletic cabbages bir 24

and so on................

any suggestions?

the code i entered is as folows:

elseif($query = "select username, p_team, count(*) as pcount from members,
players group by players.p_team, members.username having pcount > 2")
  {
    $result = mysql_query($query);
    echo("You can't pick more than 2 players from any team!");
  }

[jpmoriarty]

if you're selecting from multiple tables then you'll need some condition so it knows how they're linked

ie
select from customers, orders where customers.id = orders.customer_id

otherwise it will combine the tables every way possible (ir customer 1 will be shown with order 1, 2, 3, 4, customer 2 will be shown with order 1, 2, 3, 4 etc)