RE: Need a small modification, looking for a code god

PBlade <[email protected]> 12 Sep 2003 18:47:16 -0000

Newsgroups	gmane.comp.web.oscommerce.contributions
Message-ID	<b715be73c776b0c1ef6f6d03675e67d9@osCommerce-Forums>

This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=228499#228499
----------------------------------------------------------------

Yeah I thought about that but I have to lets the customer to choose one option, both option or none of the options. I am trying to play around with the sql statement but no luck. Hope anyone with very good knowledge with sql can help me out?
[code]
      $products_options_name = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . $HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . $languages_id . "'");
[/code]

kevin