How can i update javascript with php?

[wwfc_barmy_army]

Hello.

 

I have the following code for part of an ajax fuction:

	var a1 = document.getElementById('1').value;
var b2 = document.getElementById('2').value;
var queryString = "?a1=" + a1 + "&b2=" + b2;
ajaxRequest.open("GET", "updatedetails.php" + queryString, true);
ajaxRequest.send(null); 
}

//-->
</script>

 

Although the problem is that i need to be able to change the variables. for example i have 1, 2, 3 fields in my database. For example this code would work in php:

while ($i <= $rowcount){
$result = mysql_query("SELECT * FROM type WHERE type_id = $i") 
or die(mysql_error());  
$qry = mysql_fetch_array($result);
echo "the variable put here";
$i = $i + 1;
}

 

Something like that, but i don't know how to get it into the javascript file. Any ideas?

 

Thanks.

 

P.s. The full ajax code is here:

<script language="javascript" type="text/javascript">
<!-- 
//Browser Support Code
function ajaxFunction(){
var ajaxRequest;  // The variable that makes Ajax possible!

try{
	// Opera 8.0+, Firefox, Safari
	ajaxRequest = new XMLHttpRequest();
} catch (e){
	// Internet Explorer Browsers
	try{
		ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
	} catch (e) {
		try{
			ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
		} catch (e){
			// Something went wrong
			alert("Your browser broke!");
			return false;
		}
	}
}
// Create a function that will receive data sent from the server
ajaxRequest.onreadystatechange = function(){
	if(ajaxRequest.readyState == 4){
	var ajaxDisplay = document.getElementById('ajaxDiv');
		ajaxDisplay.innerHTML = ajaxRequest.responseText;
	}
}

var MSN = document.getElementById('MSN').value;
var Yahoo = document.getElementById('Yahoo').value;
var queryString = "?MSN=" + MSN + "&Yahoo=" + Yahoo;
ajaxRequest.open("GET", "updatedetails.php" + queryString, true);
ajaxRequest.send(null); 
}

//-->
</script>

[hansford]

let php store the values in an array and then at the end of your loop do:

 

echo "<script language='javascript'>";

 

for($i = 0; $i < sizeof($myarray); $i++){

 

echo "var num" . $myarray[$i] . "=" .  $myarray[$i] .";";

}

echo "</srcipt>";

 

now javascript has global vars named like num1, num2 etc.. which holds the values you got from you DB

[webent]

Told wwfc_barmy_army that yesterday when this post was made in the php help forum...

 

http://www.phpfreaks.com/forums/index.php/topic,200988.msg908903.html#msg908903

[hansford]

 

Well, maybe he doesn't get what we're trying to say or we don't get what he's trying to accomplish. What variables are you trying to change? please post the varibale along with the relevant code thanks

[wwfc_barmy_army]

Thanks guys!