Zen Cart Logo
Forums / Customization from the Admin / problems with ID customers

problems with ID customers

Locked

Views: 1,442

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
23 Oct 2008, 6:24 PM
#1
dinix avatar

dinix

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)

23 Oct 2008, 6:50 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: problems with ID customers

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:'";
24 Oct 2008, 3:36 PM
#3
dinix avatar

dinix

Zen Follower

Join Date:
May 2006
Posts:
102
Plugin Contributions:
0

Re: problems with ID customers

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:'";
24 Oct 2008, 5:42 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: problems with ID customers

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:

24 Oct 2008, 6:23 PM
#5
dinix avatar

dinix

Zen Follower

Join Date:
May 2006
Posts:
102
Plugin Contributions:
0

Re: problems with ID customers

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?

24 Oct 2008, 6:32 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: problems with ID customers

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

25 Oct 2008, 9:37 AM
#7
dinix avatar

dinix

Zen Follower

Join Date:
May 2006
Posts:
102
Plugin Contributions:
0

Re: problems with ID customers

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.