problems with ID customers

[dinix]

Hi I have problems wend i try to search customers with ID number in admin area.
Can you help me (soory my Ingles)

[Ajeh]

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:'"; 

[dinix]

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:'";

[Ajeh]

Keep in mind how many numbers will appear in the current search keys and what searching for a customers_id will eventually be like ...

[dinix]

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?

[Ajeh]

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

[dinix]

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.