PHP - Array_push Inside While

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;
     }
    ?>

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. 

I am trying to add new elements to an empty array using a form and submit button and the code is not adding anything from it. Here is the code I use:

<!DOCTYPE html>
<html>
	<head>
		<title>
			
		</title>
	</head>
	<body>
		<div class="site">
			<div class="menu">
				
			</div>
			<div class="head">
				
			</div>
			<div class="content">
				<form>
					<input type="text" value="" name="add"/><br/>
					<input type="submit" value="Add" name="submit"/>
				</form>
			</div>
			<div class="footer">
				
			</div>
		</div>
	</body>
</html>
<?php
$submit = $_POST["submit"];
$field = $_POST["add"];
$list = array();
if($submit){
	$psh = array_push($list,$field);
	
	echo $list;
}
	
?>

Any idea why is it not working?
 

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=316454.0