populate list field based on another list field's selection

Ok let me give you an example. If I use the normal query,

list($locRecords, $locMetaData) = getRecords(array(
'tableName' => 'locations',
'where' => 'country="whatever"',
));

It will return the fields in the locations table based on the where statement and I'll be able to loop through the images field using $locRecords['image']['isImage'], $locRecords['image']['thumbUrl'], etc variables. BUT since I need to use multiple where statements, I cannot use the above code. As far as I know, it doesn't support multiple where statements -- i.e. "where w=x AND y=z", which is what I need so I'm forced to use a standard MySQL statement to query the database:

$locRecords = mysql_query_fetch_all_assoc("SELECT * FROM cms_locations WHERE country='" . $_REQUEST['c']
. "' AND province_state='" . $_REQUEST['ps'] . "' AND city='" . $_REQUEST['ci'] . "' ORDER BY country, province_state, city");

BUT, using this does not give me the variables such as $locRecords['image']['isImage'] or $locRecords['image']['hasThumbnail'] or $locRecords['image']['thumbUrl'] (as far as I know)... how do I get those variables using a standard MySQL statement as opposed the to first code snippet.

Thanks ross, worked like a charm...

it's weird though -- that's the FIRST thing I tried and for whatever reason, it didn't work the first time. [:/]

Anywho, all is well now. Thanks again!