[RESOLVED] Array Help/Question

[condoug]

Hi

I am using this method to store data from the database into a session array variable:

	$qry	=	"SELECT url FROM mytable WHERE id = $get_id";
    $res 	= 	mysql_query($qry);
	while ($_SESSION['S_ARRAY'] [] = mysql_fetch_array($res)) {
	}
	mysql_free_result($res);

Further down the page, I now want to check if certain values are in the array and i am doing so like this:

	if (in_array("about-us",$_SESSION['S_ARRAY'])) {
		echo "Yes, it is!";
	} else {
		echo "Nope, it is not.";
	}

however even through I KNOW the value I am looking for when I am testing it is in the array, it still says it is not. here is my array:

Array
(
    [0] => Array
        (
            [0] => about-us
            [url] => about-us
        )

[1] => Array
    (
        [0] => our-services
        [url] => our-services
    )

[2] => 
)

Why is thi shappening and what am I doing wrong?

Thankyou

[condoug]

I have change the query to be the following and it still is not finding it:

	$qry	=	"SELECT url FROM mytable WHERE id = $get_id";
    $res 	= 	mysql_query($qry);
	while ($row = mysql_fetch_assoc($res)) {
		$array[]	=	$row;
	}
	mysql_free_result($res);

if (in_array("about-us",$array)) {
	echo "Hello";
} else {
	echo "Nope";
}

Array
(
    [0] => Array
        (
            [url] => about-us
        )

[1] => Array
    (
        [url] => our-services
    )

)

Where am i going wrong and how can it be fixed?

[bpat1434]

in_array searches an arrays values for a specific needle. In your case the $array array is setup wrong. In order to see if "about-us" is in the array, you'd have to do something like:

in_array('about-us', $array[0])

You'd have to do that for every item in the $array variable though, so that's not really a good answer.

Or, you can set it up differently from the get-go.

$_SESSION['S_ARRAY'] = array();

// Run your query here....

while($row = mysql_fetch_assoc($result))
{
    array_push($row['url'], $_SESSION['S_ARRAY']);
}

Now your $_SESSION['S_ARRAY'] array will look like this:

Array (
    [0] => string('about-us')
    [1] => string('our-services')
)

So now you can search $_SESSION['S_ARRAY'] for whatever value you want:

in_array('about-us', $_SESSION['S_ARRAY'])

[condoug]

Thanks for the prompt response but there is an error which says the following:

Warning: array_push() [function.array-push]: First argument should be an array

Any ideas?

[condoug]

Fixed it - just switch the stack around.

Thanks for your help bpat1434!