searching problem

[aclhkaclhk]

1. how could I search "phone" field?

2. searching subject:

- if subject is "enquiry 123456", searching 123456 has no result.
- if subject is "enquiry t:123456", search t:123456 is ok.

pls advise your searching mechanism.

[chromahoen]

You will notice at the start of building the WHERE clause that if the search string is numeric it only searches on ticketID.

In my tickets.inc.php file at line 100 it now looks like this. It works.

if(is_numeric($searchTerm)){
$qwhere.=" AND ticket.ticketID LIKE '$queryterm%'".
" OR ticket.phone LIKE '%$queryterm%'";

Hope this helps! :cool: