wmguk Posted November 3, 2009 Share Posted November 3, 2009 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> Quote Link to comment Share on other sites More sharing options...
marcus Posted November 3, 2009 Share Posted November 3, 2009 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.