while loop delema

prkarpi

Hi all.

I have this code:

		

<javascript>
..........
var dsi = new Array(
<?php
$resultTwo = mysql_query($sql);
while($rowTwo = mysql_fetch_array($resultTwo)) {
$tracks = $rowTwo['m_nameTwo'];
$incJS==1; $incJS++; 
echo "\"" . $incJS . "\","; 
}
?>
);
		for(i=0;i<dsi.length;i++) {
			if(dsi[i] != id) $("#remix_player_"+dsi[i]).html(players[dsi[i]][1]);
		}
		$("#remix_player_"+id).html(players[id][0]);
	}

</script>

This code increases the number within JavaScript array as long as while loop has data to pull from DB. The dilemma lies within the comma in "echo ...$incJS . "\",";"
Javascipt shows an error because last array cannot have comma after it. How can the code in php be manipulated to EXCLUDE the last comma in while loop? I have some ideas, but they don't seem to work in php. Thank you.

NogDog

One way would be to append the text to a variable instead of echoing it, then [man]rtrim/man-ing any trailing comma before echoing that variable.

Another approach is to build an array of quoted values, then echo with [man]implode/man to insert the commas between elements.

Yet another approach would be to build the array similar to the above, but use the [man]JSON[/man] functions to format it for use in your JavaScript.

prkarpi

Thanks nogdog.

I believe this might work...

<?php

$array = array('val1', 'val2', 'val3');
$outPut = implode(",", $array);

echo $outPut; 

?>

However, can an array carry values within (val1, val2 and so on) without putting them in there by hand? In other words - these values within an array need to be declared automatically depending on how DB responds within "while output" string. Moreover, these values are not going to be the same, i.e. it might only be one value (val1) - where would the rest of the values within an array go? Any suggestions? Thanks again.

prkarpi

any suggestions anyone? -thanks.

Weedpacket

Maybe no-one understands your question. Of course an array doesn't need to have its values listed explicitly - but you already know that, based on your original code.