# Php and msql

**URL:** <https://forum.kirupa.com/t/php-and-msql/184716>\
**Category:** Uncategorized\
**Created:** [April 7, 2006, 3:00am UTC](https://forum.kirupa.com/t/php-and-msql/184716 "2006-04-07T03:00:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gnatflim](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/gnatflim/32/2336_2.png) [@gnatflim](https://forum.kirupa.com/u/gnatflim)\
**Post date:** [April 7, 2006, 3:00am UTC](https://forum.kirupa.com/t/php-and-msql/184716/1 "2006-04-07T03:00:35Z")

</div>

this is my actionscript but its not getting the data from some reason from my php script can anyone help me in figuring out what I am doing wrong? my sites.php is below as well.

function lv(l, n, t, e, f) {  
if (l == undefined) {  
l = new LoadVars();  
l.onLoad = function() {  
var i;  
n.htmlText = “”;  
if (t == undefined) {  
n.htmlText += “\<b\>”+this[“title”+e]+"\</b\>\<br\>";  
} else {  
for (i=0; i\<this.n; i++) {  
n.htmlText += “\<class=‘menu\_item’\>\<a href=’”+this[“link”+i]+"’\>"+this[“title”+i]+"\</a\>\<br\>";  
}  
}  
};  
}  
l.load(f);  
}  
lv(sites\_txt, “cycle”, null, “sites.php”);

\<?php  
mysql\_pconnect (“localhost”, “ **", "** ”);  
mysql\_select\_db (“nathanm\_mydba”);  
$qResult = mysql\_query (“SELECT \* FROM sites ORDER BY id ASC”);  
$nRows = mysql\_num\_rows($qResult);  
$rString ="&n=".$nRows;  
for ($i=0; $i\< $nRows; $i++){  
$row = mysql\_fetch\_array($qResult);  
$rString .="&id".$i."=".$row[‘id’]."&"."&title".$i."=".$row[‘title’]."&"."&link".$i."=http://".$row[‘link’]."&";  
}  
echo $rString."&";  
?\>

---

<div class="post-metadata">

**Author:** ![gnatflim](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/gnatflim/32/2336_2.png) [@gnatflim](https://forum.kirupa.com/u/gnatflim)\
**Post date:** [April 7, 2006, 3:54am UTC](https://forum.kirupa.com/t/php-and-msql/184716/2 "2006-04-07T03:54:21Z")

</div>

Figured it out, I was not passing the ‘l’ parameter into my function