Help with Poll - PHP MYSQL database from IPB

[illusionaz]

I can't seem to figure out how to break this down from an IPB forum to show the choices and results of a poll on my site. Any help greatly appreciated

choices text Yes NULL

And here is what is inside that column:

a:1:{i:1;a:3:{s:8:\"question\";s:18:\"What do you think?\";s:6:\"choice\";a:2:{i:1;s:3:\"Yes\";i:2;s:2:\"No\";}s:5:\"votes\";a:2:{i:1;i:1;i:2;i:0;}}}

[illusionaz]

Ok I got it unserialized into an array, but I could use some help displaying the array. This is what i get when I print it.

Array ( [question] => Who is going to be the Wild Cards in the AFC? [multi] => 1 [choice] => Array ( [1] => Cincinnati [2] => Jacksonville [3] => New York Jets [4] => Kansas City [5] => Denver [6] => Other ) [votes] => Array ( [1] => 0 [2] => 0 [3] => 1 [4] => 1 [5] => 0 [6] => 0 ) )

[Cups]

If the array you mentions creates a form that users fill in, look at the HTML of the form. If the "action" is GET then you can access what the user chose by doing:

print_r($_GET);

if its a POST action then use print_r($_POST)

Is that what you mean?

[illusionaz]

I want to show the results of the poll, but I can't display the arrays inside the array. There are 2 more arrays, choice and votes.

[Cups]

I think I get you, do you mean that from your array example you should show:

Jets = 1
KC = 1

[illusionaz]

yea

[Cups]

$t = Array ( 
"question" => "Who is going to be the Wild Cards in the AFC?",  
"multi" => 1, 
"choice" => Array ( 1 => "Cincinnati", 2 => "Jacksonville", 3 => "New York Jets", 4 => "Kansas City",
5 => "Denver", 6 => "Other" ),
"votes" => Array ( 1 => 0, 2 => 0, 3 => 1, 4 => 1, 5 => 0, 6 => 0 ) 
);
print_r($t);
echo '<hr>';

foreach ($t['choice'] as $k=>$v){
echo $v . ' - ' . $t['votes'][$k] .' votes <br>' ;
} 

I know there must be a nicer way of doing it, but that works

[illusionaz]

Thank you so much i tried forever but your code worked like a charm!

[Cups]

My pleasure, honing up my array skills for my exam.

Heres one up, only show those with results > 0 and order them by number of votes, in reverse order....

$t = Array (
"question" => "Who is going to be the Wild Cards in the AFC?",  
"multi" => 1,
"choice" => Array ( 1 => "Cincinnati", 2 => "Jacksonville", 3 => "New York Jets", 4 => "Kansas City",
5 => "Denver", 6 => "Other" ),
"votes" => Array ( 1 => 0, 2 => 0, 3 => 1, 4 => 2, 5 => 3, 6 => 0 )
);

arsort($t['votes']);  // magic here

print_r($t);  // some debug
echo '<hr>'; // just a delimiter of debug

foreach ($t['votes'] as $k=>$v){

 if($t['votes'][$k] > 0 ){
   echo $v . ' - ' . $t['choice'][$k] .' votes <br>' ;
 } 
} 

Gives:
3 - Denver votes
2 - Kansas City votes
1 - New York Jets votes

Did you know there are about 80 array functions in PHP? Nor me.