putting rows from a DB into an array in php

thili

$query = SELECT question FROM surveyquestion;";

$result = mysql_query($query);
$numRows = mysql_num_rows($result);
//$numFields = mysql_num_fields($result);
//echo "$numRows;";
//echo "$numFields;";
$question = "";
for ($i=0;$i<=$numRows;$i++){
$row = mysql_fetch_array($result);
$question .= "$row[0]";
}
echo "&question=$question;";

When I run this php file on my local host it displays all the questions under &question. What I need to do is have an array so it displays the questions like:
&question[1] = .......
&question[2] = .......

and so on. How would I accomplish this ?

ahundiak

while($row = mysql_fetch_array($result))
{
$questions[] = $row[0];
}
print_r($questions);

thili

Awesome works great thanks. Now I need to import the questions into a listbox in flash. Heres my code for flash.

rQ = new LoadVars();
rQ.onLoad = function(success) {
for(i=0; i <= 5; i++){
_root.box_lb.addItem(rQ.questions[i]);
}
    _root.box_lb.height = 600;
    _root.box_lb.width = 700;
};
rQ.sendAndLoad("mysql.php", rQ, "POST");

The only thing I am seeing in the listbox though is a , for each row. I don't think my handler 'rQ.questions' is correct. Anyone have any ideas ?

ahundiak

Sorry but I don't do flash. It's trivial to generate a html option string from the array. Don't know if that would help.