sql query results to js array?

[mmikkelson]

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

[speedracer]

I'll move this question to javascript forum.

[nolachrymose]

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

Hope that helps!

Happy coding!

[mr_ego]

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?>";
<?
}
}

?>

[mmikkelson]

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