load MySQL data into JavaScript array

[AP81]

Is it possible to load MySQL data into JavaScript array?

I want to do this as I want to use a javascript autocomplete function for a textbox. The problem is I need to load all the mySQL data into a JavaScript array.

I have the code working using a listbox (load all my MySQL data into a listbox), however it just seems to slow. I'm assuming if they are in an Array, they will be a lot quicker.

Is this possible?

Thanx

[AP81]

Figured out how to do it:

echo "<script>";
echo "var serialarray=new Array()\n";
$arraypos = 0;
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
	foreach ($line as $col_name=>$col_value) 
  	{
   		echo "serialarray[" . $arraypos . "]=" . "'" . $col_value . "'" . "\n";

}
$arraypos++;
 }
 echo "</script>";