how to look for a field value in db base on relatived filed value?

[linjuming]

I forgot such a zencart function, it can look for any field value base on other field value in zencart db. what is it?

[lat9]

You could try

$sql_query = "SELECT orders_status_id
                   FROM   " . TABLE_ORDERS_STATUS . "
                   WHERE  orders_status_name = 'Pending'
                   AND language_id='1'";

$sql_result= $db->Execute($sql_query);

Note that I added the language_id, too, just in case you've got a multilingual store.

[linjuming]

thank you very much