Splitting a table into three groups

[sametch]

I am trying to divide the records returned from a table into three "equal" groups alphabetically.

I am using a for loop and switch to divide the groups up as shown below:

switch ($i)
{
case ($i >= $aStart && $i <= $aEnd):
$aValues = $aValues . $i . " = ". $letter . "<br>";
break;

case ($i >= $bStart && $i <= $bEnd):
$bValues = $bValues . $i . " = ". $letter . "<br>";
break;

case ($i >= $cStart && $i <= $cEnd):
$cValues = $cValues . $i . " = ". $letter . "<br>";
break;
}

The values for the comparitors are:

$aStart = 0 $aEnd = 4
$bStart = 5 $bEnd = 8
$cStart = 9 $cEnd = 12

Each time the results for the first run i.e when i=0 end up in the second group when it should clearly end up in the first.

It driving me mad.

here is the output:

1 = b
2 = c
3 = d
4 = e


0 = a
5 = f
6 = g
7 = h
8 = i


9 = j
10 = k
11 = l
12 = m

does anyone know why?

sametch

[DoppyNL]

I'm not completely sure what you're actually trying to do, I think it's this:

you want to run a mysql-query, and after that, split the result into 3 arrays of (almost) the same number of records, in alfabeticle order.

if so, run you're query, use "mysql_num_rows($result);" to get the number of records, then get them a record at a time, and place them in whatever array you want (or split them in 3 if you want)

Hope this helps...

Greetz Daan

[sametch]

Thanks

I will give that a try for the future. In the meantime I have soolved it by replacing the switch statement with three seperate if() statements, performing the same logic. For some reason switch does not behave correctly when i=0. This leaves me well confused

sametch