to fetch multiple rows here.and if fetch it dissapear very fast as row is fluctuating

hello frds,
in this function
function update()
{
rw=document.getElementById('tbls1').rows.length;
var x=document.getElementById('tbls1').insertRow(rw);
//document.getElementById('tbls1').rules="rows";
var root = r.parentNode;

var w=x.insertCell(0);
var y=x.insertCell(1);
var z=x.insertCell(2);
var a=x.insertCell(3);
//var p=x.insertCell(4);
//alert(document.getElementById('tbls1').rows[0].innerHTML);
w.width="2%";
y.width="30%";
z.width="50%";
a.width="5%";
//p.width="5%";
w.align="right";
y.align="left";
z.align="left";
a.align="left";

//alert(frm2.unt.value);
<?php
$con = pg_connect("dbname=fa user=postgres");
$rt="select a.led_name,b.subled_name,c.* from t_fa_voucher c inner join t_fa_ledger a on a.led_id=c.ledg_id inner join t_fa_subledger b on c.subledg_id=b.subled_id and (c.vch_no='".$_POST['unt']."' and c.sr_no<>0)";

$rt1=pg_query($con,$rt);
if($rt1)
{
while($rt2=pg_fetch_array($rt1))
{?>
// b=0;

w.innerHTML="<?php echo $rt2[7]; ?>";
y.innerHTML="<?php echo $rt2[0];?>";
z.innerHTML="<?php echo $rt2[1];?>";
a.innerHTML="<?php echo $rt2[10];?>";


//alert(document.getElementById('tbls1').rows[0].innerHTML);

<?php

}
}
?>
//alert(h.innerHTML);
}

i needed to fetch data from mysql table.currently data is fetched but as inserted into javascript templates the data is not gng to fetch multiple rows here.and if fetch it dissapear very fast as row is fluctuating.
plz advice me .

thx

 

If you want to fetch data from a MySql table, why are you connecting to a Postgres Server?

 

create html table and show the results

execute the query using mysql_query($qry)

since u want access mysql table