Multiple Dimensional Arrays problem again

supermario25

Hi all,

Again, I am having problems with multiple dimensional arrays. Here it is:
I am trying to input data into the array from a MySQL query as follows:

for($i=0; $i<$q; $i++) { 
for($j=0; $j<$a; $j++) { 

$result2= mysql_query($sql2) or die (mysql_error());

//$ques results in a correct value from the database
$ques= mysql_result($result2, "$questions[$i]");

//Attempt to input data into array in two ways: [1] (not both ways at same time)
$questions2 = array("[$i]" => array("[$j]" =>"$ques"));
//[2] second way
$questions2[$i][$j]= "$ques";

//and I attempt to output as below for($k=0; $k<$q; $k++) { 
for($l=0; $l<$a; $l++) { 
echo "question " . $questions2[k][l] . "<br />";
}
}

//the output is
question 
question 
question 
....

Any help you can give me will be appreciated, Thank you in advance,
Mario

AndreF

I don't think you should have the sql things within the loop.

$result2= mysql_query($sql2) or die (mysql_error());

//$ques results in a correct value from the database
$ques= mysql_result($result2, "$questions[$i]");

put them before loop.

bradgrafelman

When posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.

supermario25

AndreF wrote:
I don't think you should have the sql things within the loop.

$result2= mysql_query($sql2) or die (mysql_error());

//$ques results in a correct value from the database
$ques= mysql_result($result2, "$questions[$i]");

put them before loop.

Thank you for the quick reply.
I cannot do that since I am retrieving information from the database dynamically as shown below:

$sql2="SELECT count($questions[$i]) FROM questions WHERE $questions[$i]='$answers[$j]'";