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)
Views: 1,442
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:'";
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:
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 ...
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.