My code

PHP Code:

<?
$i = 0;
$query = mysql_query("SELECT * FROM news");
while($row = mysql_fetch_array($query)){
    $i++;
}
?>
var numofoptions =<? if($i == 0){ $i = 0; } else { $i = $i+1; } echo $i; ?>;
var testArr = new Array(numofoptions);
testArr[0] = document.getElementById("teletext_inner").innerHTML;
<?
$query1 = mysql_query("SELECT * FROM news");
while($row1 = mysql_fetch_array($query1)){
    echo 'testArr['.$row1['id'].'] = "'.$row1['content'].'";';
}
?>
setTimeout("changetele(0)",waittime);
// Comment

is there any easier way to do this?

Try this:

PHP Code:

<?php
$query1 = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM news");
$output_config = true;
while($row1 = mysql_fetch_array($query1)){
  if ($output_config) {
    $output_config = false;
    $num_rows_result = mysql_fetch_array(@mysql_query($link,"Select FOUND_ROWS() AS total_rows"));
    ?>
var numofoptions =<? if($num_rows_result['total_rows'] == 0){ $num_rows_result['total_rows'] = 0; } else { $num_rows_result['total_rows'] = $num_rows_result['total_rows']+1; } echo $num_rows_result['total_rows']; ?>;
var testArr = new Array(numofoptions);
testArr[0] = document.getElementById("teletext_inner").innerHTML;
    <?php
  }
  echo 'testArr['.$row1['id'].'] = "'.str_replace('"','\"',$row1['content']).'";';
}
?>

I didn't run this, but the idea should be enough. The change to $row1['content'] is to escape double-quotes.

is there anyway to get it so I don't have to use the ID as the array #?

Sure. This is javascript arrays. This demonstrates the method:

<script type="text/javascript">
var testArr = [];
testArr.push("My First Value");
testArr.push("My Second Value");

for (var i=0; i< testArr.length; i++) {
  document.write("<p>" + testArr[i] + "</p>");
}
</script>

So can you explain a little more on how I would use it with the JS that I am using already?

bump.