prevent so put a name two times

[devil_online]

Hi, I have this code and this is the result
as you notice it apears the same name two times in the same week

How can I pretent this

thanks

$conter = 0; 
$week = 1;
$size = count($names);

for($i=0; $i < $size; $i++)
{
	if($conter == 2)
	{
		$conter = 0;
		$week++;
	}		 
	echo "Insert $names[$i] in week $week<br />";

$conter ++;
}
  

Result:
Insert Porto Sporting in week 1
Insert Benfica Porto in week 1
Insert Braga Benfica in week 2
Insert Benfica Sporting in week 2
Insert Sporting Benfica in week 3
Insert Porto Braga in weeka 3
Insert Porto Benfica in week 4
Insert Sporting Braga in week 4
Insert Sporting Porto in week 5
Insert Braga Sporting in weeka 5
Insert Benfica Braga in week 6
Insert Braga Porto in week 6

[leatherback]

Hi,

I am not sure what you are asking here. You talk about the same name twice in the same week? I do not see this happening, to be honest.. Each name appears only once

[devil_online]

for example in week 1 Porto apears two times

Insert Porto Sporting in week 1
Insert Benfica Porto in week 1

thanks

[ClarkF1]

can you post the initialisation of the $names array so we can see what the actual values are

[leatherback]

Ah, ok.
Yeah, see clarks comment. By the time you arrive at the code you just showed us the names array is already filled, and it is filled with appearently the wrong values (Didn't realize that these were two names, was looking for twice "Benfica Porto")

[devil_online]

the array is this
$name = array('Sporting', 'Benfica', 'Braga', 'Porto');

thanks

[tbbd]

you have this $i < $size

make that <= and see what happens, right now the loop will stop at when $i becomes 2...
just glancing at it from work, so have no way to actually test it out, but that appears that it may be an issue

[laserlight]

You are clearly trying to write some kind of league pairing system. Perhaps you could outline your algorithm, and the expected results?

tbbd wrote:

you have this $i < $size

make that <= and see what happens, right now the loop will stop at when $i becomes 2...
just glancing at it from work, so have no way to actually test it out, but that appears that it may be an issue

No, that is not an issue. Your proposal will result in what amounts to an array out of bounds error.

[Weedpacket]

Of course, the given $name array and the given code does not produce the given output. There is obviously something missing from what has been given. Like, how is $names generated from $name?

[ClarkF1]

Assuming it's a typo and instead of $name you meant $names

Running this script

<?
$names = array('Sporting', 'Benfica', 'Braga', 'Porto');

$conter = 0;
$week = 1;
$size = count($names);

for($i=0; $i < $size; $i++)
{
    if($conter == 2)
    {
        $conter = 0;
        $week++;
    }        

    echo "Insert $names[$i] in week $week<br />";

$conter ++;
?>

gives me

Insert Sporting in week 1
Insert Benfica in week 1
Insert Braga in week 2
Insert Porto in week 2

[devil_online]

laserlight wrote:

You are clearly trying to write some kind of league pairing system. Perhaps you could outline your algorithm, and the expected results?

yes your right

this is the result that I want

Result:
Insert Porto VS Sporting in week 1
Insert Benfica VS Porto in week 1
Insert Braga VS Benfica in week 2
Insert Benfica VS Sporting in week 2
...

the variable $name is corect

thanks

[leatherback]

Why don't you show us the code you have, the code which produced the list you showed in the first post? The code you gave us before, combined with the names table you posted, DO NOT give you the list you claim it produced.

[devil_online]

nop
I just wanto to make a rule that don't insert the same name two times in a week

thanks

[ahundiak]

Do it at the database level:

CREATE UNIQUE INDEX some_name ON table_name (name,week);

Any attempt to insert a record with the same name/week combo will fail. You will want to catch this error gracefully.