Zen Follower
- Join Date:
- May 2006
- Posts:
- 102
- Plugin Contributions:
- 0
problems with ID customers
Hi I have problems wend i try to search customers with ID number in admin area.
Can you help me (soory my Ingles)
Zen Follower
Hi I have problems wend i try to search customers with ID number in admin area.
Can you help me (soory my Ingles)
Oba-san
There isn't a customers_id search ... the search works only on name, email, phone, street, company, city, postal-code:
$search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or c.customers_telephone rlike ':keywords:' or a.entry_company rlike ':keywords:' or a.entry_street_address rlike ':keywords:' or a.entry_city rlike ':keywords:' or a.entry_postcode rlike ':keywords:'";
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Zen Follower
Tanks for de wanser
I just change the code and works
$search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_id like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%' or c.customers_telephone rlike ':keywords:' or a.entry_company rlike ':keywords:' or a.entry_street_address rlike ':keywords:' or a.entry_city rlike ':keywords:' or a.entry_postcode rlike ':keywords:'";
Oba-san
Keep in mind how many numbers will appear in the current search keys and what searching for a customers_id will eventually be like ... :unsure:
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Zen Follower
Yes 1 to 4 customers appear wend i shearch for customers id but it´s ok for me, i need the id customers it´s important. and the test i make works ok
tanks for everyting and if you now beter code let me now ok?
Oba-san
You might consider a separate search for the customers_id rather than use it as part of the generic ...
Peek in orders.php to see how the separate searches are done there for ideas on how to do this ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Zen Follower
tanks
I dont now wo to do a separate search. If you now sameting and if you can help me it´s ok.
Is working +/- with code i change.
tanks for everyting.
Tell staff why this post should be reviewed.