I would like to know if we can select data from the database using php and assign it to a javascript array? if so what would be the syntax?
I wrote the code below but it is not working
$js_array = "[";
$result = mysql_query("SELECT item_name FROM tbl_item");
while( $row=mysql_fetch_array($result, MYSQL_NUM) ) {
$js_array .= $row[0];
$js_array .= ",";
}
$js_array{ strlen($js_array)-1 } = ']';
?>
<script>
var cities = <?php echo $js_array; ?>
for(var i=0; i<4;i++)
alert(cities.length);
</script>