[RESOLVED] Searching an Array

partypete

Hello,

I'm trying to use a variable to search an array created by MySQL query.

Let's say I have this query:

mysql_select_db($database_myconn, $myconn);
$query_rs_cars = "SELECT car_id, car_make FROM cars";
$rs_cars = mysql_query($query_rs_cars, $myconn) or die(mysql_error());
$row_rs_cars = mysql_fetch_assoc($rs_cars);
$totalRows_rs_cars = mysql_num_rows($rs_cars);

$row_rs_cars should now contain info such as:

[code]car_id car_make

1 Ford
2 Chevy
3 Honda
4 Mazda
5 BMW[/code]
Now from a different query I have created the variable $owners_car_id with the value of 2.

What I would like to do is use the value 2 from $owners_car_id, and search car_id in the array and echo it's matching car_make. In this case it should echo Chevy.

I've read through a couple of PHP's array functions such as array_search() and in_array() but haven't been able to find what I'm looking for. Any ideas?

Thanks!!!
Peter

partypete

Actually, I just used a LEFT JOIN in the second query to get the matching car_make for the owners_car_id.

But just out of curiousity, is it possible to do what I mentioned in my previous post?

Thanks as always!

Installer

Actually, after running the code you posted, "$row_rs_cars" will contain only one row, the first:

array('car_id' => '1', 'car_make' => 'Ford')

To get all the rows into a (2-dimensional) array, you'd need to loop the "fetch" statement:

mysql_select_db($database_myconn, $myconn); 
$query_rs_cars = "SELECT car_id, car_make FROM cars"; 
$rs_cars = mysql_query($query_rs_cars, $myconn) or die(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) {
    $row_rs_cars[] = $row;
}

$row_rs_cars will then be:

array(
'0' => (array('car_id' => '1', 'car_make' => 'Ford'),
'1' => (array('car_id' => '2', 'car_make' => 'Chevy'),
'2' => (array('car_id' => '3', 'car_make' => 'Honda'),
'3' => (array('car_id' => '4', 'car_make' => 'Mazda'),
'4' => (array('car_id' => '5', 'car_make' => 'BMW'))

and then you can search for the car_id like this:

$owners_car_id = '2';
foreach ($row_rs_cars as $sub_array) {
    if ($sub_array['car_id'] == $owners_car_id) {
        echo $sub_array['car_make'];  // Chevy
    }
}

Or you can construct a one-dimensional array:

mysql_select_db($database_myconn, $myconn); 
$query_rs_cars = "SELECT car_id, car_make FROM cars"; 
$rs_cars = mysql_query($query_rs_cars, $myconn) or die(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) {
    $row_rs_cars[$row['car_id']] = $row['car_make'];
}

$row_rs_cars will then be:

array(
'1' => 'Ford',
'2' => 'Chevy',
'3' => 'Honda',
'4' => 'Mazda',
'5' => 'BMW')

then the search is just a matter of using the id as the key:

$owners_car_id = '2';
echo $row_rs_cars[$owners_car_id];  // Chevy

partypete

Wow, thanks Installer!

I can see the examples you created coming in very handy.

Much appreciated.

Peter