I need someone who knows oscommerce. YOU MUST KNOW the OSCOMERCE system.
I am needing a db query changed.
I have added STORE_ID to the configuration table of oscommerce.
I added store_id to the CUSTOMERS table.
I am needing to make [url removed, login to view] (file attached) only show customers that the value of store_id in the customers table is the same as STORE_ID from configuration. I have included the [url removed, login to view] file also - so you can see how I have changed it to make it insert the store id in store_id. I think this is the query below that needs to be changed.:
$customers_query_raw = 'select c.customers_id, c.customers_username, c.customers_lastname, c.customers_firstname, customers_private_messages, c.customers_notes as notes, c.customers_email_address , c.customers_group_id, cg.customers_group_name, c.customers_group_ra, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, z.zone_name as state, ctry.countries_iso_code_2 as country, a.entry_country_id, a.entry_company from ' . TABLE_CUSTOMERS . ' c left join ' . TABLE_ADDRESS_BOOK . ' a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join ' . TABLE_CUSTOMERS_GROUPS . ' cg on c.customers_group_id = cg.customers_group_id left join ' . TABLE_CUSTOMERS_INFO . ' ci on c.customers_id = ci.customers_info_id left join ' . TABLE_COUNTRIES . ' ctry on a.entry_country_id = ctry.countries_id left join ' . TABLE_ZONES . ' z on a.entry_zone_id = z.zone_id ' . $search . ' order by ' . $db_orderby . ' ' . $sort;
6 freelancers are bidding on average $68 for this job
Ready to start immediately on your project, as we are the experts in such things. Waiting for your selection. Thanks!
Hello Sir We are an offshore well established company for about more than five years. We have experienced developers (PHP, ASP, ASP.NET, MYSQL, C#,JAVA,JSP, C++ etc.) and those are dedicated in their respective fields. Daha Fazla
Dear Sir Hello, I am Alex Smith. I have 4 year experience in the php fields as a freelancer and job experience.I have done lot of successful projects.I had worked on several UK,USA and other countries p Daha Fazla
Sir. I can help you. I have lots of experience in what you are asking. Plz contact me.