[RESOLVED] Problem with ARRAY

[lelyea]

I am attempting to assign a mysqli result to a searchable array. My Code:

@ $db = new mysqli($hst, $usnm, $pwd, $dbs);

$query="SELECT facid, rel_coord, payable FROM `release_coordinator` "; 
$result = $db->query($query) or die(mysqli_error());
$release_array = array();	
while($row = mysqli_fetch_assoc($result)) { 
	$release_array[] = $row; 		
}
$db->close();
$result->free();	

print_r($release_array);
echo "<br />";
$facid = "59846";
if(in_array($facid, $release_array)) {
	echo "<br />";
	echo "Found it!";	
}

The print_r($release_array); output:

Array ( [0] => Array ( [facid] => 62345 [rel_coord] => release [payable] => 3 ) [1] => Array ( [facid] => 59846 [rel_coord] => coord [payable] => 3 ) [2] => Array ( [facid] => 46546 [rel_coord] => release [payable] => 3 ) )

The $facid = "59846";
if(in_array($facid, $release_array)) {

fails to locate the "59846". Any help greatly appreciated.
(Been at this and searching the web for hours)
Thanks,

Len

[halojoy]

$release_array is one array with 3 rows arrays inside.
We can say $release_array is just a container,
but the actual data is inside those 3 arrays, rows, inside.

in_array() searches the container for something
but finds only 3 arrays, but no real data

what you need do is to make a loop,
looping 3 times, or at least until the value is found

[man]foreach[/man] is what I use most

<?php
/*
$release_array = 
Array ( 
	[0] => Array ( [facid] => 62345 [rel_coord] => release [payable] => 3 ) 
	[1] => Array ( [facid] => 59846 [rel_coord] => coord [payable] => 3 ) 
	[2] => Array ( [facid] => 46546 [rel_coord] => release [payable] => 3 )
)
*/

echo '<pre>';
print_r($release_array);
echo '</pre>';
echo "<br />";

$facid = "59846";
$found = false;
foreach($release_array as $row){
	if($row['facid'] == $facid){
		$found = true;
		//break out of foreach loop, we need search no more
		break;	
	}
}

echo "<br />";
if($found)
	echo "Found it! ".$facid;
else
	echo $facid." not found"

?>

[kkobashi]

If I am reading your code right, you are selecting ALL records from the release_coordinator table. Then iterating through all resulting records trying to find facid=59846.

This is highly inefficient and you aren't using the database for what its for - finding things.
Isn't this what you want instead?

  SELECT facid, rel_coord, payable FROM release_coordinator where facid=59846;

You just want the rows with facid=5986 right...

[halojoy]

Yes. I agree.
This is absolutely the simple and best way,
if he only wants to find one record based on 'facid'

[lelyea]

Thanks Halojoy - works great!!

Actually, post from Halojoy was exactly what I needed - a searchable array to query from another HUGE return from an MS SQL query which has numerous loops, loop counters etc.

THANKS!!