So here's the deal. I need to querie a table 600 times. i need to count each field that matches 1 - 100. But i need to do that for 6 different fields in the table. How can i do this.?
i can get 1 but not 2, how can i setup a sub-query?
<?php
for($i=1;$i<=100;$i++){
$p1[$i] = $i;
$query_getsub=mysql_query("SELECT COUNT(pick_1) as pick1 FROM lottery_all where pick_1 = '$p1[$i]'")or die(mysql_error());
//$query_getsub.=mysql_query("SELECT COUNT(pick_2) as pick2 FROM lottery_all where pick_2 = '$p1[$i]'")or die(mysql_error());
$num_fields = mysql_num_fields($query_getsub);
$j=0;
$x=1;
while($row=mysql_fetch_array($query_getsub)){
for($j=0;$j<$num_fields;$j++){
$name = mysql_field_name($query_getsub, $j);
$objectpick_1[$x][$name]=$row[$name];
echo " <tr><td>$i = {$objectpick_1[$x][pick1]}</td></tr>";
}$x++;
}
}
?>
Make sense?
Ok OK I had a brain fart,
for($i=1;$i<=5;$i++){
$p7[$i] = $i;
$query_getsub7=mysql_query("SELECT COUNT(power_play) as pick7 FROM lottery_all where power_play = '$p7[$i]'") or die(mysql_error());
$num_fields = mysql_num_fields($query_getsub7);
$j=0;
$x=1;
while($row=mysql_fetch_array($query_getsub7)){
for($j=0;$j<$num_fields;$j++){
$name = mysql_field_name($query_getsub7, $j);
$objectpick_7[$x][$name]=$row[$name];
$pick7[$i] = $objectpick_7[$x]['pick7'];
}$x++;
}
}
// Output values
for($i=1;$i<=55;$i++){
$total[$i] = $pick_1[$i]+$pick2[$i]+$pick3[$i]+$pick4[$i]+$pick5[$i]+$pick6[$i];
echo "<tr bgcolor=\"#FFFF66\"><td align=center bgcolor=\"#33FF99\"><b>$i</b></td><td align=center>{$pick_1[$i]}</td><td align=center>{$pick2[$i]}</td><td align=center>{$pick3[$i]}</td><td align=center>{$pick4[$i]}</td><td align=center>{$pick5[$i]}</td><td align=center>{$pick6[$i]}</td><td align=center>{$pick7[$i]}</td><td align=center bgcolor=\"#8E8BCF\">{$total[$i]}</td></tr>";
}
