Hello Team,

Thank you for great application that is simple to install and very nice to use.

I have installed your module in my site: checkphone.org/

But cam across next problem. In my table there is a first column with mobile phone IMEI (TAC) number, I would like to search models by this number, but I don't want to show these numbers in column.

I means that if visitor types IMEI number and this number exists in database - it appears.

I switched first column to "Hidden" stage in your module settings and search does not work any more by this column.

Please prompt how I may have search available by hidden column.

Thank you very much for your effort.

Hello,

The extension doesn't support this ability. A possible solution is creating a search form outside the module and send search string from the form to the module. It is possible to use request variables in "WHERE" of SQL query (if you show data from a database) or in filters (if data from a CSV file).

Variables are used in the following way:

{$REQUEST:VAR_NAME}

Where VAR_NAME is a name of request parameter.

Regards,
ARI Soft

Thank you very much for the quick answer.

I have done it, but still have a problem.

Like you you check checkphone.org/?TAC=0

returns right result, because TAC exists, but when I open page without any variables like this: checkphone.org/

It returns error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''%') LIMIT 0, 100' at line 1 SQL=select DISTINCT * from t8dsv_phones where TAC like CONCAT(,'%') LIMIT 0, 100

because there is no TAC variable and {$REQUEST:VAR_NAME} is empty.

this is an SQL request:

select DISTINCT * from t8dsv_phones where TAC like CONCAT({$REQUEST:TAC},'%') LIMIT 0, 100


Could you please advise.

Use the following query:

select DISTINCT * from t8dsv_phones where TAC like CONCAT({$REQUEST:TAC|empty:''},'%') LIMIT 0, 100

Regards,
ARI Soft

This works well ! Great thanks.