[RESOLVED] in_array problem

[kbc1]

Hi all,

Hopefully a simple one for you. I am gathering a selection of ID's from my database and storing these id's into a session array:

$_SESSION['S_APPROVAL_IDS'][]

Further down my page, i run a check to see if an ID from a 2nd query exists in my session array, and if it does, I want to display a 'checked' checkbox, and if it doesn't, obviously display an 'unchecked' checkbox.

Here is a snippet of that code:

		while ($datarow = mysql_fetch_array($result)) {
			$approvalid = $datarow['approvalid'];

	if (in_array($approvalid, $_SESSION['S_APPROVAL_IDS'])) {
		$checkbox = "<input checked name=\"appselected\" type=\"checkbox\" class=\"appcheckbox\" value=\"1\" onclick=\"CountSelectedApprovals(document.centreapprovals);\" />";
	} else {
		$checkbox = "<input name=\"appselected\" type=\"checkbox\" class=\"appcheckbox\" value=\"1\" onclick=\"CountSelectedApprovals(document.centreapprovals);\" />";
	}

The problem I am having is that even though I know the ID does actually exist in my session array, i my checkbox will still not display the checked value.

I have used print_r to display the contents of my session array which proves I have the id in my array:

Array
(
    [0] => Array
        (
            [0] => 243101
            [approvalid] => 243101
        )

[1] => 
)

Does anyone have any suggestions as to why the checkbox is always unchecked?

Thanks in advance.
k

[bogu]

Create your session arr like this:

$_SESSION['S_APPROVAL_IDS'][0] = '123123';
$_SESSION['S_APPROVAL_IDS'][1] = '12312';
$_SESSION['S_APPROVAL_IDS'][2] = '1231';
....
$_SESSION['S_APPROVAL_IDS'][99] = '123';

[kbc1]

Hi,

This is how I am building my session array though:

$approvalquery = "SELECT DISTINCT approvalid FROM tblapproval";
$searchresult = mysql_query($approvalquery);
	while ($_SESSION['S_APPROVAL_IDS'][] = mysql_fetch_array($searchresult)) {
		}
    	mysql_free_result($searchresult);

How would I build my session arrays like you suggested using this method?

And what would it achieve by doing it the way you suggested?
Thanks

[bogu]

Sugestion:

$approvalquery = "SELECT DISTINCT approvalid FROM tblapproval"; 
$searchresult = mysql_query($approvalquery); 
while ($rez = mysql_fetch_assoc($searchresult)) { 
    $_SESSION['S_APPROVAL_IDS'][] = $rez['approvalid'];
} 
mysql_free_result($searchresult);

Have fun codding. 😃

[kbc1]

That worked a treat!

Cheers for your help.