please any help using php and javascript

[manamino]

please help me
I want inside a javascript function to bring data from database using php and put them in javascript array so that I can use them later, example after that alert the array like that:
function lolo()
{
var p=0;
var id=new array();

<?
$sql1=mysql_query("select * from sanction s, student st, officer o where s.Id=st.Id and s.Oid=o.Oid",$db);
while($row = mysql_fetch_array($sql1, MYSQL_NUM))
{?>
id[p]=<?=$row["Id"]?>;
p=p+1;
<?
}?>
var x=0;
for(x=0; x<=p; x++)
{
alert(id[x]);
}
}

this is the function but unfortunately not working any help!!!!!!!!

[n8dnx]

manamino:

The problem is that you're code assumes that the Javascript and the PHP code are executed concurrently. In actuality, the PHP code is executed to produce the output for the browser. That output contains the Javascript and no PHP code. Once the entire script is sent to the browser, the Javascript code is executed.

Perhaps what you want to do is to use PHP to echo out the necessary Javascript code to initialize the entire id array with all of the data in it.

Having said that, there are means to interactively work between PHP and Javascript, but frankly that's an entirely different animal. Get this working first.

Chuck