PHP - Array_push() Not Adding Anything To Array

Hello all.  I'm pretty new to this, but I'm trying to build a script that will write random questions for a quiz app that I'm working on.  The data is contained in two different tables.  I'm trying to randomize the question order that is spit out, as well as randomize the answer order that is displayed.  The output has to be in the specific JSON string that is denoted in the code.  There are no errors when I go the url that I load the script, however, the string is not populated with any of the data from my tables (it is just an empty set of strings in the JSON format that the program requires.  Could someone please take a look at this and tell me where I'm going wrong.  I've checked that the query is pulling from the correct databases so I know that's not the problem.  Thank you in advance.

Code: [Select]
<?php
    //Connect To Database
    $hostname="";
    $username="";
    $password="";
    $dbname="";
    $question_table="wp_mtouchquiz_question";
    $answer_table="wp_mtouchquiz_answer";
    
    $yourfield = "question";
    $question = "question";
    $answer = "answer";
    $connection = mysql_connect($hostname, $username, $password);
    $lastQuestionID = -1;
    $str = "";
    mysql_select_db($dbname, $connection);   

 # Check If Record Exists
    
    $query = "SELECT * FROM $question_table q, $answer_table a WHERE q.ID = a.QUESTION_ID AND q.quiz_id = 1 ORDER BY question_id ASC, correct DESC";
    
    $result = mysql_query($query);
    $questions = array();
    $fields = array(); 
    
    if($result)
    {
        while($row = mysql_fetch_array($result))
        {
            if($lastQuestionID != $row["question_id"])
            {
                $fields = array();
                if($lastQuestionID != -1)
                {
                    array_push($questions, $fields);
                }
                $fields = array();
                $lastQuestionID = $row["question_id"];
                $fields["question_id"] = $row["question_id"];
                $fields["question"] = $row["question"];
            }
            // correct
            if($row["correct"] == 1)
            {
                $fields["correct"] = $row["answer"];
            }
            // incorrect
            if ($row["sort_order"] ==2)
            {
                $fields["incorrect0"] = $row["answer"];
            }
            // incorrect
            if ($row["sort_order"] ==3)     
            {
                $fields["incorrect1"] = $row["answer"];
            }
            // incorrect
            if ($row["sort_order"] ==4)
            {
                $fields["incorrect2"] = $row["answer"];
            }
            
            if ($row["sort_order"] ==5)
            {
                $fields["incorrect3"] = $row["answer"];
            }
        }
        
        $str .= "{\"childItems\":[";
        
        $numQuestionsToUse = 172; //Set this larger than returned questions or less than row limit / 5
        
        $randomQuestionKeys = array_rand($questions, $numQuestionsToUse);
        $numQuestions = count($randomQuestionKeys);
        for($i = 0; $i < $numQuestions ; $i++){
            $pickedField = $questions[$randomQuestionKeys[$i]];
            
            $str .= "{\"itemId\":\"question" . $pickedField["question_id"] . "\",";
            $str .= "\"itemType\":\"BT_questionItem\",";
            $str .= "\"questionText\":\"" . $pickedField["question"] . "\","; 
            $str .= "\"correctAnswerText\":\"" . $pickedField["answer"] . "\",";
            
            $incorrectAnswers = array();
            array_push($incorrectAnswers, $pickedField["incorrect0"]);
            array_push($incorrectAnswers, $pickedField["incorrect1"]);
            array_push($incorrectAnswers, $pickedField["incorrect2"]);
            array_push($incorrectAnswers, $pickedField["incorrect3"]);
                                                        
            $incorrectAnsKey = array_rand($incorrectAnswers, 3);
            $str .= "\"incorrectText1\":\"" . $incorrectAnswers[$incorrectAnsKey[0]] . "\",";
            $str .= "\"incorrectText2\":\"" . $incorrectAnswers[$incorrectAnsKey[0]]  . "\",";
            $str .= "\"incorrectText3\":\"" . $incorrectAnswers[$incorrectAnsKey[0]]  . "\",";  
            $str .= "\"imageURLSmallDevice\":\"http://www.myquizcoach.com/extras/images/clear_header.png\",";
            $str .= "\"imageURLLargeDevice\":\"http://www.myquizcoach.com/extras/images/clear_header.png\"},";
         }
                                                        
         // remove last comma
        $str = substr($str,'',-1);
        $str .= "] }";
        echo $str;
     }
    ?>

Hey guys I have the following script that correctly retrieves 2 values from mysql: security_code and selected_address:
The problem I have, is how can I add the retrieved values (more than 1 row) inside an array called $data


$data = array();
$result = mysql_query("SELECT security_code, selected_address FROM purchase WHERE purchase_id = '412012' AND selected_address = 'General Roca 900' ORDER BY `offers_bought`.`security_code` ASC"); 
$cant = 0; 
while($row=mysql_fetch_array($result))
{
array_push($data[$row['selected_address']], $row['security_code']);
        $cant++;
}


The array_push function gives me the following error:
Warning: array_push() [function.array-push]: First argument should be an array in C:\wamp\www\Test\test\excelTest.php on line 24

In other words this is want I want to achieve:
$data = array(array("selected_address" => $row['security_code']));
Only that this example adds only 1 retrieved row

Any ideas?
Thanks in advance!
Cheers,

Our disc golf league uses a little PHP script that I developed (stealing lots of code in the process) that sucks in a list of league players from a text file, lets you select the ones that show up on league day, and randomly assigns the selections into foursomes and threesomes (Demo: http://edge.byethost18.com/demo4/foursomes.php)

Here's a modified example using letters of the alphabet:
https://neth.roe3.org/mdrone/ABCs/foursomes.php

. . . and the code:
https://neth.roe3.org/mdrone/ABCs/foursomes.txt

The actual version uses the shuffle() function to randomize the assignments and has a refresh button to reshuffle the assignments if a grouping contains bitter enemies. I disabled it in the example in order to show how the "A-B-C"s are assigned to the groups. As you can see, it assigns "A" to the first group, "B" to the second group, "C" to the third group and so on until it reaches the last group and then starts back at group 1 with the next letter.

One of the our players wants a modification. He wants to be able to assign players into foursomes/threesomes according to their handicaps (best to worst). In other words, Group 1 would contain A, B, C, D. Group 2 would contain E, F, G, H and so on. Naturally, this would depend on which player checkboxes are selected, but the order is maintained.

What I am having trouble with is getting the "A-B-C"s assigned into groups in the order they are listed in the text file.

I tried using array_chunk() in the following script:

https://neth.roe3.org/mdrone/ABCs/foursomes2.php

. . . and the code:
https://neth.roe3.org/mdrone/ABCs/foursomes2.txt

In a nutshell, here's the code that's doing the work . . .

$numgroups = $d;
if($howmany % 4 == 0) {
 $numgroups = '4';
} 

$rows = array_chunk($players,$numgroups); 

$x=0;
foreach ($rows as $row) {
$cnt=$x+1;
    echo "<b><font color='#F44336'>Group ".$cnt."</font></b><br/>";
    echo "<ul>";
      foreach ($row as $value) {
         print "<li>" . $value . "\n";
        }
    echo "</ul>";
  $x++;
 }
 
Unfortunately, I have a mental block when it comes to getting it to create groups like the original (which I prefer). For instance, if you select all items in the original script, Groups 6 & 7 will contain 3 items each.  When you select all items in the array_chunk() version, Groups 6 & 7 contain 4 items and 2 items respectively.  The same occurs if you select 10 items: the original script groups |4|3|3| and the array_chunk() version groups |4|4|2|. 

I'm sure there's a simple solution. I'm just not seeing it. I'm really just a hobbyist . . . not a real programmer by any stretch of the imagination.

Thanks for any help anyone can send my way. BTW . . . if anyone is interested in the foursomes generator source, I'm happy to share it. It could probably use improvement. 

Using curl_multi, I have loaded up 3 url's and then printed the array.

1) How can I also set a timestamp on output to let me know when each url was run?

2) How can I explode the array to only display the data and timestamp, excluding the text "Array ( =>", "[1] =>", "[2] =>" and " )"? Code

<?php

function multiRequest($data, $options = array()) {

  // array of curl handles
  $curly = array();
  // data to be returned
  $result = array();

  // multi handle
  $mh = curl_multi_init();

  // loop through $data and create curl handles
  // then add them to the multi-handle
  foreach ($data as $id => $d) {

    $curly[$id] = curl_init();

    $url = (is_array($d) && !empty($d['url'])) ? $d['url'] : $d;
    curl_setopt($curly[$id], CURLOPT_URL,            $url);
    curl_setopt($curly[$id], CURLOPT_HEADER,         0);
    curl_setopt($curly[$id], CURLOPT_RETURNTRANSFER, 1);

    // post?
    if (is_array($d)) {
      if (!empty($d['post'])) {
        curl_setopt($curly[$id], CURLOPT_POST,       1);
        curl_setopt($curly[$id], CURLOPT_POSTFIELDS, $d['post']);
      }
    }

    // extra options?
    if (!empty($options)) {
      curl_setopt_array($curly[$id], $options);
    }

    curl_multi_add_handle($mh, $curly[$id]);
  }

  // execute the handles
  $running = null;
  do {
    curl_multi_exec($mh, $running);
  } while($running > 0);

  // get content and remove handles
  foreach($curly as $id => $c) {
    $result[$id] = curl_multi_getcontent($c);
    curl_multi_remove_handle($mh, $c);
  }

  // all done
  curl_multi_close($mh);

  return $result;
}



$data = array(array(),array());

$data[0]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Pearl+Jam&output=json';
$data[1]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Black+Eyed+Peas&output=json';
$data[2]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Nirvana&output=json';

$r = multiRequest($data);

print_r($r);

?>

Output

Array ( => Pearl Jam [1] => Black Eyed Peas
        [2] => Nirvana )

Preferred Output

01:00:01 Pearl Jam
01:00:02 Black Eyed Peas
01:00:03 Nirvana