sql query results to js array?

Is it possible to dynamically drop the results of a SQL query into a javascript array?

I'll move this question to javascript forum.

You could do a loop through all of the results and populate the JS array like that.

Hope that helps!

Happy coding! :)

This is theroretical, not guarenteed.



var jsarray = new Array();

<?

$sql = "DESCRIBE table";
$query = mysql_query($sql);

while ($_SQL = mysql_fetch_array($query)) {
$_ITEM[$_SQL['field']] = $_SQL;
}

$sql = "SELECT * FROM table";
$query = mysql_query($sql);

$i = -1;

while ($_SQL = mysql_fetch_array($query)) {
++$i;
echo "jsarray[$i] = new Array();";
foreach ($_ITEM AS $fieldname => $_FIELD) {
echo "jsarray[$i][$fieldname] = "{$_SQL[$fieldname]}";
}
}

?>




Like i said. 100% theroretical.

You could try this too...

<?

$sql = "SELECT * FROM table";
$query = mysql_query($sql);

$i = -1;

while ($_SQL = mysql_fetch_array($query)) {
++$i;
?>
jsarray[<?php echo $i?>] = new Array();
<?
foreach ($_SQL AS $fieldname => $fieldvalue) {
?>
jsarray[<?php echo $i?>][<?php echo $fieldname?>] = "<?php echo $fieldvalue?>";
<?
}
}

?>

thanks to both of you
i'm very new to javascript and i figured i could drop the results of a SQL query into an array, but wasn't sure about how to go about it.

thanks for the suggestions and example