<pre>
| id | color | subcolor | price |
| 1 | blue | lightblue | 0,50 |
| 2 | blue | lightblue | 0,51 |
| 3 | blue | lightblue | 0,52 |
| 4 | blue | darkblue | 0,60 |
| 5 | blue | darkblue | 0,70 |
| 6 | blue | blue098 | 0,80 |
| 7 | green | litegreen | 0,52 |
| 8 | green | darkgreen | 0,70 |
| 9 | yellow | yellow21 | 0,40 |
</pre>
I have to output:
e[0]=('0','blue')
e[1]=('1','green')
e[2]=('2','yellow')
c[0]=('lightblue','lightblue','0')
c[1]=new Array('darkblue','darkblue','0')
c[2]=new Array('blue098','blue098','0')
c[3]=new Array('litegreen','litegreen','1')
c[4]=new Array('darkgreen','darkgreen','1')
c[5]=new Array('yellow21','yellow21','2')
To output e[]=('','') i'm using this code below, and it works fine:
$query = "SELECT db1.color,db1.subcolor FROM db1";
$result = mysql_query($myquery, $db);
$x=0;
while ( $row = mysql_fetch_row($result))
{
if ($row[0] == $old_row){ }
else {
$vari_e .= "e[$x]=($x,'$row[0]')\n";
$x++;}
$old_row = $row[0];
}
But I don't know what to do to generate
c[]=('','','')
Any ideas?
