Đã Đóng

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;

Kĩ năng:

Xem nhiều hơn: 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

Về Bên Thuê:
( 6 nhận xét ) Knoxville, United States

ID dự án: #85442

6 freelancer đang chào giá trung bình $68 cho công việc này


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

$100 USD trong 3 ngày
(153 Nhận xét)

Can help you within 2 hours. Thanks!

$30 USD trong 0 ngày
(480 Nhận xét)

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

$30 USD trong 1 ngày
(571 Nhận xét)

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. Thêm

$100 USD trong 5 ngày
(99 Nhận xét)

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 Thêm

$100 USD trong 2 ngày
(2 Nhận xét)

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

$50 USD trong 2 ngày
(0 Nhận xét)