[RESOLVED] PHP to output Javascript array...

[clubbedougan]

I have the following scripto:

<script type="text/javascript">

	//Secify scroller contents
	var line=new Array()		

	<?

            // db connection bit not included on forum post

	$sql = "SELECT * FROM ccl_news ORDER BY id LIMIT 5";
	$res = mysql_query($sql);

	while ($row = mysql_fetch_array($res)) {

	echo 'line[($i)]="' $row[1] . '"';

	}

	?>

</script>

Basically, in the perfect world, I would load the page and it would echo out:

	<script>

//Secify scroller contents
var line=new Array()
line[1]="This is an awesome script"
line[2]="It brings up the text you want..."
line[3]="One letter at a time"
line[4]="You can add and subtract lines as you like."
line[5]="It\'s very cool and easy to use"

</script>

I've tried my code but keep getting parse errors galore.

If anyone can shed some light on this, I would be forever in their debt.

Thankyou for your time and help!

[dougal85]

your perfect world example forgets the line delimiters ;

what does $i do in your PHP? Where does it come from? can we see the output you are getting?

[clubbedougan]

Here's some revised code

<script type="text/javascript">

    //Secify scroller contents
    var line=new Array()        

    <?

$sql = "SELECT title FROM ccl_news ORDER BY id LIMIT 5";
$res = mysql_query($sql);
$row = mysql_fetch_array($res, MYSQL_NUM);

foreach ($row as $key=>$r) {

echo "line[$key]= \"$r\"\n";

}
        ?>

</script>

But it only echo's out one row 🙁

I have three records when I run the query in me db. So it should show 3 if it were werkin'

My perfect world's went and done a runner me thinks.

[dougal85]

<script type="text/javascript">

    //Secify scroller contents
    var line=new Array()        

    <?

$sql = "SELECT title FROM ccl_news ORDER BY id LIMIT 5";
$res = mysql_query($sql);

while ($row = mysql_fetch_array($res, MYSQL_NUM)) {


foreach ($row as $key=>$r) {

echo "line[$key]= \"$r\"\n";

}

}
        ?>

</script>

Guessing a bit since i don't know how your database is set up.

[clubbedougan]

Hello dougal,
Thanks for your help.

I managed to find the following code which did the job:

<?php
$sql = "SELECT `title` FROM `ccl_news` ORDER BY `id` LIMIT 5";
IF ($res = mysql_query($sql) AND mysql_num_rows($res)) :
  echo "<script type='text/javascript'>\n";
  echo "var line=new Array()\n";
  $key = 1;
  WHILE ($row = mysql_fetch_assoc($res)) :
    echo "line[$key] = \"{$row['title']}\";\n";
    $key++;
  ENDWHILE;
  echo "</script>\n";
ENDIF;
?> 

[bradgrafelman]

Don't forget to mark this thread resolved.