How do you assign a value of a varaiable within a while do loop?

James2002

Hi everyone. I've been attempting to assign the value to a variable, with a different value being assigned at every pass of the while loop. I've created an array to store the value, this value is then passed into the paranthesis of a function within the 'onclick' function of an anchor.

I've created an array which in turn is assigned to a value stored inside a mysql db. However, with every loop it displays the last value of the loop. I understand this is normal with loops if the value is not implemented corectly. Can anyone shed some light on this subject please? The code is listed below:

$myArray = array();
$count = 0;

while($rows=mysql_fetch_array($result)) {

$id = $rows['reply_id'];
$myArray[$count] = $rows['content_id'];
$content = $rows['content'];
$username = $rows['username'];
$image = $rows['image'];

?>


	<tr>
		<td>

			<a href="#open-report" class="login-window" name="open-report"  onclick="<?php echo $myString = sendID($myArray[$count]); ?>">View Report</a>
		</td>
	</tr>

<?php

	$count ++;	

}

cretaceous

The whole point of the "while" function is that it steps through the data - so no need to put the results in an array and then get them out again.

You don't need the $count value here either - if you do this:
$myArray[] = $rows['content_id'];
then the array will automatically increment the key value on each loop starting from 0

and what is sendID here:
echo $myString = sendID($myArray[$count]);
??

James2002

Thanks for replying.

The 'sendID()' function is simply a function that returns the current ID this function is to be redesigned as soon as I get the ID to return the current value of content_id, I've tried implementing '$myArray[] = $rows['content_id'];', but that doesn't work either.

Whenever I echo the current value of the varaible it displays a list of the correct values from the db, however, whenever I pass the variable to the function it simply displays the last value of the loop. I've tried numerous variants of arrays including the current() function but nothing seems to work.

cretaceous

just do echo $myArray[$count];
dump "$myString = sendID("

looks like you are mixing javascript and PHP

James2002

Thanks. I'm going to research how to call a function from an anchor as I can't use it in the href as I'm using this to call a jquery lightbox.

cretaceous

Just be aware that unless you are using AJAX, you can pre-populate a js array from PHP code, but it's static and you can't call a dynamic bit of PHP from it. Sorry bad terminology. You may know that.

You could do
onclick="sendID(<?php echo $myArray[$count] ?>)"

(might need an inner pair of single quotes inside the brackets)

I still don't know what your $mystring= is doing in there... !

James2002

Thanks. I'm going to go down the AJAX route and redesign the majority of the code.