Adding PHP to javascript

[wmguk]

hi,

 

how can I get my script to read my database?

 

This script works, but only shows the first result, and doesnt show anything after that...

 

<?php
include ("Scripts/connection.php");
$qry1 = "SELECT * FROM news";
$result1 = mysql_query($qry1);
?>
<script type="text/javascript">
/*Example message arrays for the two demo scrollers*/
var pausecontent=new Array()
<?php
while($news = mysql_fetch_array($result1)) 
{ 
$i = 0;
?>
pausecontent[<? echo $i; ?>]='<a href="news.php#<?php echo $news['id']; ?>"><?php echo $news['news']; ?></a><br /><?php echo $news['news']; ?>!'
<?php 
$i ++;
}
?>
</script>

[marcus]

Each time you loop through the database you're continuously setting variable i back to 0, and then adding one back to it.

 

Define variable i before the while loop begins, and remove the definition of it from the contents of the while loop.