help filling javascript array with PHP/MySql values

[Kaspa]

hello, I hope I can get some help, I have been trying to fill this
javascript array with PHP values for a while now and I am about to
quit, here is the javascript array that I would like to fill out

I = new Array();

I[0] = new Array();
I[0][0]='this is question';
I[0][1] = new Array();
I[0][1][0] = new Array();
I[0][1][0][0]='right answer a';
I[0][1][0][1]='right answer feeedback';
I[0][1][0][2] = 1;
I[0][1][1] = new Array();
I[0][1][1][0]='wrong answer b';
I[0][1][1][1]='wrong answer feedback b';
I[0][1][1][2] = 0;
I[0][1][2] = new Array();
I[0][1][2][0]='wrong answer c';
I[0][1][2][1]='wrong answer feedback c';
I[0][1][2][2] = 0;
I[0][1][3] = new Array();
I[0][1][3][0]='wrong answer d';
I[0][1][3][1]='wrong answer feedback d';
I[0][1][3][2] = 0;
I[0][1][4] = new Array();
I[0][1][4][0]='wrong answer e';
I[0][1][4][1]='wrong answer feedbac e';
I[0][1][4][2] = 0;
I[0][2] = 0;

I[1] = new Array();
I[1][0]='this is question 2';
I[1][1] = new Array();
I[1][1][0] = new Array();
I[1][1][0][0]='right answer a 2';
I[1][1][0][1]='right answer feeedback 2';
I[1][1][0][2] = 1;
I[1][1][1] = new Array();
I[1][1][1][0]='wrong answer b 2';
I[1][1][1][1]='wrong answer feedback b 2';
I[1][1][1][2] = 0;
I[1][1][2] = new Array();
I[1][1][2][0]='wrong answer c 2';
I[1][1][2][1]='wrong answer feedback c 2';
I[1][1][2][2] = 0;
I[1][1][3] = new Array();
I[1][1][3][0]='wrong answer d 2';
I[1][1][3][1]='wrong answer feedback d 2';
I[1][1][3][2] = 0;
I[1][1][4] = new Array();
I[1][1][4][0]='wrong answer e 2';
I[1][1][4][1]='wrong answer feedbac e 2';
I[1][1][4][2] = 0;
I[1][2] = 0;
.
.
.the number of question may vary

can somebody help me iterate trough this code filling out the array
from a database table. Are there any PHP function that would make
this easier, any help is appreciated. Here is my code so far...

Status = new Array();

<?PHP
require_once("config.php");
require_once("includes/sql_layer.php");
$dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);
$sql = "SELECT
nuke_quizz_data.pollID,
nuke_quizz_data.optionText,
nuke_quizz_data.optionCount,
nuke_quizz_data.voteID,
nuke_quizz_desc.pollID,
nuke_quizz_desc.pollTitle,
nuke_quizz_desc.timeStamp,
nuke_quizz_desc.voters,
nuke_quizz_desc.qid,
nuke_quizz_desc.answer,
nuke_quizz_desc.coef,
nuke_quizz_desc.good,
nuke_quizz_desc.bad,
nuke_quizz_desc.comment";
$sql .= " FROM
nuke_quizz_data,
nuke_quizz_desc
WHERE
nuke_quizz_desc.pollid = nuke_quizz_data.pollid";
$result = mysql_query($sql);

$type = "";
$number2 = "0";

while ($myrow = mysql_fetch_row($result)) {

if ($myrow[0] != $type) {
if ($number2 != NULL) {
$newnumber2 = ($number2 + "1");
print ("I[$number2] = new Array();\n");
$number2 = $newnumber2;
$type = $myrow[0];
$number = "0";
}
}
print "I[" . ($number2 - "1") . "]";
if ($number != NULL) {
$newnumber = ($number + "1");
print ("[$number]");
$number = $newnumber;
}
}
?>

[Andrew Wilson]

On 7/20/02 1:27 AM, in article
e6bb142.02071...@posting.google.com, "Kaspa"
<kaspa...@hotmail.com> wrote:

> hello, I hope I can get some help, I have been trying to fill this
> javascript array with PHP values for a while now and I am about to
> quit, here is the javascript array that I would like to fill out
>
>

[snip]

Have you looked at

http://www.devshed.com/Server_Side/MySQL/JS_Arrays/page1.html

Andrew Wilson
AJW Web Services
Www.ajwwebservices.com