OsCommerce Modification

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;


Lihat lagi: value city, php modification, db query, cg, notes search, modification pending order, Need Modification, sort table, oscommerce table, select country state city php, join file, modification system, file notes, search query, oscommerce order order, sort file, php state country city, value table, city search, modification need

Tentang Majikan:
( 6 ulasan ) Knoxville, United States

ID Projek: #85442

6 pekerja bebas membida secara purata $68 untuk pekerjaan ini


Ready to start immediately on your project, as we are the experts in such things. Waiting for your selection. Thanks!

$100 USD dalam 3 hari
(153 Ulasan)

Can help you within 2 hours. Thanks!

$30 USD dalam 0 hari
(480 Ulasan)

i have finished more complex problem ,please contact with me .

$30 USD dalam sehari
(571 Ulasan)

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. Lagi

$100 USD dalam 5 hari
(99 Ulasan)

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 Lagi

$100 USD dalam 2 hari
(2 Ulasan)

Sir. I can help you. I have lots of experience in what you are asking. Plz contact me.

$50 USD dalam 2 hari
(0 Ulasan)