Forums / General Questions / how to look for a field value in db base on relatived filed value?

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

Started by linjuming on 23 Nov 2012, 8:27 AM · Views: 1,645

Results 1 to 3 of 3

23 Nov 2012, 8:27 AM

linjuming

Zen Follower

Join Date:: Apr 2012
Posts:: 151
Plugin Contributions:: 0

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

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

23 Nov 2012, 1:12 PM

lat9

Administrator

Join Date:: Sep 2009
Location:: Stuart, FL
Posts:: 14,120
Plugin Contributions:: 56

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

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.

My website

24 Nov 2012, 1:48 AM

linjuming

Zen Follower

Join Date:: Apr 2012
Posts:: 151
Plugin Contributions:: 0

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

thank you very much